{"id":38399,"date":"2018-11-17T14:13:00","date_gmt":"2018-11-17T08:43:00","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=38399"},"modified":"2021-12-07T11:20:16","modified_gmt":"2021-12-07T05:50:16","slug":"qlikview-data-types","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/qlikview-data-types\/","title":{"rendered":"QlikView Data Types &#8211; Dual Data Format &amp; Interpretation, Representation"},"content":{"rendered":"<p align=\"justify\">In our last tutorial, we discussed the\u00a0<a href=\"https:\/\/data-flair.training\/blogs\/qlikview-quick-chart-wizard\/\"><strong>QlikView\u00a0Quick Chart Wizard<\/strong><\/a>. Here, we come with a new topic, QlikView Data Types. Moreover, we will learn dual data format, data interpretation, and data representation of Data Types in QlikView.<\/p>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">QlikView has a unique story for its data types and how they work. Pay special attention if you interested in the tool from a developer\u2019s point of view. Because a good understanding of data types will help you in the long run.<\/span><\/span><\/p>\n<p align=\"justify\">So, let&#8217;s start QlikView Data Types Tutorial.<\/p>\n<div id=\"attachment_38409\" style=\"width: 1210px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Dual-Data-Type-01.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-38409\" class=\"size-full wp-image-38409\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Dual-Data-Type-01.jpg\" alt=\"\" width=\"1200\" height=\"628\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Dual-Data-Type-01.jpg 1200w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Dual-Data-Type-01-150x79.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Dual-Data-Type-01-300x157.jpg 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Dual-Data-Type-01-768x402.jpg 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Dual-Data-Type-01-1024x536.jpg 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Dual-Data-Type-01-520x272.jpg 520w\" sizes=\"auto, (max-width: 1200px) 100vw, 1200px\" \/><\/a><p id=\"caption-attachment-38409\" class=\"wp-caption-text\">QlikView Data Types &#8211; Dual Data Format &amp; Interpretation, Representation<\/p><\/div>\n<h3 align=\"justify\">What is QlikView Data Types?<\/h3>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">Unlike any other programming language or a software relying on it, <a href=\"https:\/\/data-flair.training\/blogs\/qlikview-tutorial\/\"><strong>QlikView<\/strong><\/a> does not follow a standard defined data types system. The most commonly used data types in programming languages generally are int, float, double, string, array etc. Such data types can use by several RDBMS as well. <\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">A question that now must be buzzing in your head is why there are no data types in QlikView? And how does it store and interpret data values load in its memory? Well, be patient as we unfold this mystery. To start with, the reason for no data type is that QlikView needs the flexibility to be able to load data from different sources using data values having varied data types. <\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">As we know, QlikView loads data from various data sources like Excel files, databases like SAP, Oracle, then from CSV files, XML files, <strong><a href=\"https:\/\/data-flair.training\/blogs\/qvd-files\/\">QVD files<\/a><\/strong> etc. All of these different data sources use different sets of defined data types or some do not use any at all.<\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"> In such a scenario, if QlikView also sticks to a defined or standardized data type and evaluates data values formatted only in that data type, then the situation will go a little out of hand. Many conversions of data types between source and QlikView has to perform which in turn will demand efforts from QlikView\u2019s end like more resources, more time for converting data types and a much slower processing speed. This will also make the system prone to errors.<\/span><\/span><\/p>\n<p align=\"justify\"><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-delimited-file\/\">Do you know what is QlikView Delimited File (CSV)?<\/a><\/strong><\/p>\n<h3 align=\"justify\">The Solution for No Data Types in QlikView<\/h3>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">So, instead of relying on the data types of the source and making things complex, QlikView opted for not using any traditional data types for the data values loaded in its memory.<\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">Having no data type initially turned some professionals and developers against this idea and made them sceptical about data safety. But however, this did not last for long as the rationale and benefits of this system far outweighed the objections. <\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">The \u2018No data type\u2019 concept lets the associations between data fields and feasible because regardless of the data types used at the data source, all the values take a uniform code of data identity and easily associate with a similar data value.<\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">Instead of following traditionally used data types, QlikView uses certain methods of data interpretation and representation. The data values in QlikView can represent in two ways (text or number) and stores in two parts (of a single unit); String part and a Number part.<\/span><\/span><\/p>\n<h3 align=\"justify\">QlikView Data Types &#8211; Modes of Representation<\/h3>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">Data loaded from any type of data source, will stores internally into QlikView in two forms i.e. <\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><i>String<\/i><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"> and <\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><i>Number.<\/i><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"> It can also said that string and number are the two modes of representation of data stored in QlikView.<\/span><\/span><\/p>\n<ul>\n<li><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"> The <em>string type,\u00a0<\/em>widely used as dimension values of fields in a table, or values in a list box and other sheet objects. <\/span><\/span><\/li>\n<li><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">The <em>number representation, use<\/em>\u00a0when numeric values uses which can also use in sorting and calculations.<\/span><\/span><\/li>\n<\/ul>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"> During loading of data in QlikView from source, how a data value must represent and decide by QlikView itself. <\/span><\/span><\/p>\n<h3>QlikView Data Types &#8211; Dual Data Format<\/h3>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">The issues regarding QlikView and data types in section 2 of this tutorial lead the developers to come to an ingenious solution. To counter the issues, the concept of <\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><i>Dual data format<\/i><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"> was introduced in QlikView. At the core of this concept is the fact that every data value being stored in QlikView stores in two forms or two parts i.e. a string part and a corresponding number part.<\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"> Any field value will display using the string part and sorting and calculation actions will do using the number part. These two forms of data of a value cannot use separately, they occur in a pair. For instance, if a date is being loaded into QlikView, then that date will have a pair of string-number data formats.<\/span><\/span><\/p>\n<p align=\"justify\"><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-operators\/\">Follow this link to explore QlikView Operators<\/a><\/strong><\/p>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">Following the dual data format, months store in two ways, a string like Jan, Feb, Mar and so on. And, a corresponding number value to each month\u2019s string value (refer table). Similarly, each weekday will have a string value (Mon, Tue, Wed, Thu etc.) and a corresponding number value (from 0 to 6). However, colors functions not store in two data formats because they only consist of a string type and the number part is left empty.<\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">Dates also store in dual format. The date can be written in any format, it will be read by QlikView because the dual data format values are present. Similarly, time also register. An important thing to note here is that date and time\u2019s string representation will also have numbers in it, like, 21\/09\/2018 and 12:30. But, this does not mean that it is their number representation. <\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">The digits used to show date and time are a part of their string representation. The number part is a sequence of unique digits and represents individually giving the date and time identity during calculations and sorting.<\/span><\/span><\/p>\n<table dir=\"ltr\" style=\"height: 199px\" border=\"1\" width=\"251\" cellspacing=\"0\" cellpadding=\"0\">\n<colgroup>\n<col width=\"175\" \/>\n<col width=\"293\" \/><\/colgroup>\n<tbody>\n<tr>\n<td><strong>\u00a0 \u00a0 \u00a0 Text (Date)<\/strong><\/td>\n<td><strong>\u00a0 \u00a0 \u00a0 \u00a0 Num(Date)<\/strong><\/td>\n<\/tr>\n<tr>\n<td>\u00a0 \u00a0 \u00a0 \u00a08\/24\/75<\/td>\n<td>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 27630<\/td>\n<\/tr>\n<tr>\n<td>\u00a0 \u00a0 \u00a0Dec 17 1981<\/td>\n<td>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 29937<\/td>\n<\/tr>\n<tr>\n<td>\u00a0 \u00a0 \u00a09\/2\/85<\/td>\n<td>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 31292<\/td>\n<\/tr>\n<tr>\n<td>\u00a0 \u00a0 \u00a011\/16\/99<\/td>\n<td>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 36480<\/td>\n<\/tr>\n<tr>\n<td>\u00a0 \u00a0 \u00a002,04,2001<\/td>\n<td>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 36983<\/td>\n<\/tr>\n<tr>\n<td>\u00a0 \u00a0 \u00a02009-05-13<\/td>\n<td>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 39946<\/td>\n<\/tr>\n<tr>\n<td>\u00a0 \u00a0 \u00a05\/16\/14<\/td>\n<td>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 41775<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">The months, weeks, days, dates and time format for representation defined in QlikView script editor by default. Any calculations on the date and time used the number part of the dual format and perform the calculation on it, giving the final result and displaying it again as a string. <\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">Functions also use the dual format in QlikView function\u2019s parameter. The function only uses one of the two format types to evaluate in the function. It decides which data format, from string and number, should take. However, mostly all the functions return the result in dual data format. <\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">You can also define and create a new data value with a pair of dual values (string and number) defined by you. The syntax of the function is,<\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Courier New, serif\"><span style=\"font-size: large\">Dual(s,n)<\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">Where, the \u2018s\u2019 is the parameter where you define a string or display value for the field and \u2018n\u2019 is the number or numeric value for the field. <\/span><\/span><\/p>\n<h3 align=\"justify\">Qlikview Data Types &#8211; Data Interpretation<\/h3>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">The data loaded into QlikView can interpret in two different ways;<\/span><\/span><\/p>\n<div id=\"attachment_38408\" style=\"width: 1210px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Qlikview-Data-Types-Data-Interpretation-01.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-38408\" class=\"size-full wp-image-38408\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Qlikview-Data-Types-Data-Interpretation-01.jpg\" alt=\"Qlikview Data Types - Data Interpretation\" width=\"1200\" height=\"628\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Qlikview-Data-Types-Data-Interpretation-01.jpg 1200w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Qlikview-Data-Types-Data-Interpretation-01-150x79.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Qlikview-Data-Types-Data-Interpretation-01-300x157.jpg 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Qlikview-Data-Types-Data-Interpretation-01-768x402.jpg 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Qlikview-Data-Types-Data-Interpretation-01-1024x536.jpg 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Qlikview-Data-Types-Data-Interpretation-01-520x272.jpg 520w\" sizes=\"auto, (max-width: 1200px) 100vw, 1200px\" \/><\/a><p id=\"caption-attachment-38408\" class=\"wp-caption-text\">Qlikview Data Types &#8211; Data Interpretation<\/p><\/div>\n<h4 align=\"justify\">i. Numeric Interpretation<\/h4>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">If a data value like a number, date, time, currency, loaded into QlikView\u2019s memory, they interpreted in a certain way depending on whether the value\u2019s data type defined or not. A correct interpretation of the data gets loaded, necessary because QlikView has no data type of it\u2019s own.<\/span><\/span><\/p>\n<p align=\"justify\"><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-server-load-sharing-clustering\/\"><strong>Let&#8217;s Learn QlikView Server Load Sharing (Clustering)<\/strong><\/a><\/p>\n<h5 align=\"justify\">a. Defined<\/h5>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">The data values set to have a defined data type or format when they already have a data format when they upload. QlikView just reads the pre-defined formatted data value and displays it as it is. Like a string of date or time or currency value represents\u00a0as per the formatting is done at the source before loading into QlikView. <\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">With number values, the original source format store in QlikView\u2019s memory and can restore in case any change in the format has been made by the user. <\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">The default defined formats for data values are:<\/span><\/span><\/p>\n<ul>\n<li>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">Integer (default format for number)<\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">Floating point numbers (for number)<\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">Currency (for currency)<\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">Time (for time, by ISO standard formatting)<\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">Date (for date, by ISO standard formatting)<\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">Timestamp (for date and time, by ISO standard formatting)<\/span><\/span><\/p>\n<\/li>\n<\/ul>\n<h5 align=\"justify\">b. Not Defined<\/h5>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">Data interpretation of such values whose format did not define at the source interpreted by QlikView by analysing six factors. <\/span><\/span><\/p>\n<ul>\n<li>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">Way in which data is written at the source.<\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">Format settings of the operating system for date, time and currency.<\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">Optional number-interpreting variables.<\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">Optional formatting functions and\u00a0<\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">interpretation functions.<\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">Document\u2019s number formatting controls. <\/span><\/span><\/p>\n<\/li>\n<\/ul>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">A reliable way to confirm whether the data values interpreted correctly or not is by checking for string values on left and number values on right of a list box. However, for values in the same field, interpretations may vary.<\/span><\/span><\/p>\n<p align=\"justify\"><strong><a href=\"https:\/\/data-flair.training\/blogs\/skewness-in-qlikview-statistics\/\">Must Refer &#8211; QlikView Skewness (Skew)<\/a><\/strong><\/p>\n<h4 align=\"justify\">ii. Date and Time Interpretation<\/h4>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">The date, time and timestamp values in a data set interpreted slightly differently. They store as a date serial number which refers to later, during a date and time calculations comparing two intervals etc.<\/span><\/span><\/p>\n<ul>\n<li>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">The serial number used to as an identity for the date and time values and is the count of a number of days passed since 30<\/span><\/span><sup><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">th<\/span><\/span><\/sup><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"> December 1899. The period in the range is 1<\/span><\/span><sup><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">st<\/span><\/span><\/sup><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"> March 1900 to 28<\/span><\/span><sup><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">th<\/span><\/span><\/sup><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"> February 2100. For example, serial number 35648 represents 1997-08-06.<\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">The serial number used for Time values is any value\/number (including decimal point values) between 0 and 1. For example, the serial number 0.99999 is the value for time 23:59:59. <\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">The serial numbers for timestamps (date + time) is a value having mixed numbers. For example, the value 2.5 corresponds to January 1, 1990 at 12:00 noon. <\/span><\/span><\/p>\n<\/li>\n<\/ul>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">Let us understand this with the help of an example. In below table, we see how several serial numbers interpreted by QlikView according to different formats.<\/span><\/span><\/p>\n<div id=\"attachment_38407\" style=\"width: 1015px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/datatype3.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-38407\" class=\"size-full wp-image-38407\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/datatype3.png\" alt=\"QlikView Data Types \" width=\"1005\" height=\"279\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/datatype3.png 1005w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/datatype3-150x42.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/datatype3-300x83.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/datatype3-768x213.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/datatype3-520x144.png 520w\" sizes=\"auto, (max-width: 1005px) 100vw, 1005px\" \/><\/a><p id=\"caption-attachment-38407\" class=\"wp-caption-text\">QlikView Data Types &#8211; Date and Time Interpretation<\/p><\/div>\n<p align=\"justify\">So, this was all about QlikView Data Types Tutorial. Hope you like our explanation.<\/p>\n<h3 align=\"justify\">Conclusion<\/h3>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">In this tutorial, we learned about a unique fact about QlikView data types i.e. Dual data Format. We saw how in QlikView, every data value has two types of data formats; string and number. In addition, we learned about modes of data interpretation and about dual data format in detail. Still had a query\/doubt feel free to write us!<\/span><\/span><\/p>\n<p align=\"justify\">Related Topic &#8211; <strong><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-backup-and-restore\/\">QlikView Backup and Restore<\/a><\/strong><\/p>\n<p align=\"justify\"><strong><a href=\"https:\/\/help.qlik.com\/en-US\/qlikview\/November2017\/Subsystems\/Client\/Content\/Scripting\/data-types.htm\">Reference<\/a><\/strong><\/p>\n<p><span hidden class=\"__iawmlf-post-loop-links\" data-iawmlf-links=\"[{&quot;id&quot;:1732,&quot;href&quot;:&quot;https:\\\/\\\/help.qlik.com\\\/en-US\\\/qlikview\\\/November2017\\\/Subsystems\\\/Client\\\/Content\\\/Scripting\\\/data-types.htm&quot;,&quot;archived_href&quot;:&quot;http:\\\/\\\/web-wp.archive.org\\\/web\\\/20190627164412\\\/http:\\\/\\\/help.qlik.com:80\\\/en-US\\\/qlikview\\\/November2017\\\/Subsystems\\\/Client\\\/Content\\\/Scripting\\\/data-types.htm&quot;,&quot;redirect_href&quot;:&quot;&quot;,&quot;checks&quot;:[{&quot;date&quot;:&quot;2025-12-09 21:22:43&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2025-12-14 19:33:11&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2025-12-25 18:34:25&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-01-08 19:55:45&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-01-13 01:59:36&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-01-16 10:33:17&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-01-29 13:56:07&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-02-09 08:20:55&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-02-26 16:03:04&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-04-16 05:25:12&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-04-23 01:51:11&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-05-15 10:06:07&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-06-06 07:18:27&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-06-17 10:21:19&quot;,&quot;http_code&quot;:503},{&quot;date&quot;:&quot;2026-06-25 02:32:03&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-06-29 16:56:53&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-07-05 04:57:04&quot;,&quot;http_code&quot;:200}],&quot;broken&quot;:false,&quot;last_checked&quot;:{&quot;date&quot;:&quot;2026-07-05 04:57:04&quot;,&quot;http_code&quot;:200},&quot;process&quot;:&quot;done&quot;}]\"><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In our last tutorial, we discussed the\u00a0QlikView\u00a0Quick Chart Wizard. Here, we come with a new topic, QlikView Data Types. Moreover, we will learn dual data format, data interpretation, and data representation of Data Types&#46;&#46;&#46;<\/p>\n","protected":false},"author":6,"featured_media":38409,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[47],"tags":[17216,17220,17214,17217,17218,17213,17219,17215],"class_list":["post-38399","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-qlikview","tag-data-interpretation","tag-data-types-in-qlikview","tag-date-interpretation","tag-dual-data-format","tag-modes-of-representation","tag-numeric-interpretation","tag-qlikview-data-types","tag-time-interpretation"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>QlikView Data Types - Dual Data Format &amp; Interpretation, Representation - DataFlair<\/title>\n<meta name=\"description\" content=\"QlikView Data Types - What is Data Types in QlikView, QlikView Dual Data Format, Data Interpretation, Modes of Representation of Data in QlikView, Numeric\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/data-flair.training\/blogs\/qlikview-data-types\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"QlikView Data Types - Dual Data Format &amp; Interpretation, Representation - DataFlair\" \/>\n<meta property=\"og:description\" content=\"QlikView Data Types - What is Data Types in QlikView, QlikView Dual Data Format, Data Interpretation, Modes of Representation of Data in QlikView, Numeric\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/qlikview-data-types\/\" \/>\n<meta property=\"og:site_name\" content=\"DataFlair\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataFlairWS\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-11-17T08:43:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-12-07T05:50:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Dual-Data-Type-01.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"DataFlair Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DataFlair Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"QlikView Data Types - Dual Data Format &amp; Interpretation, Representation - DataFlair","description":"QlikView Data Types - What is Data Types in QlikView, QlikView Dual Data Format, Data Interpretation, Modes of Representation of Data in QlikView, Numeric","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/data-flair.training\/blogs\/qlikview-data-types\/","og_locale":"en_US","og_type":"article","og_title":"QlikView Data Types - Dual Data Format &amp; Interpretation, Representation - DataFlair","og_description":"QlikView Data Types - What is Data Types in QlikView, QlikView Dual Data Format, Data Interpretation, Modes of Representation of Data in QlikView, Numeric","og_url":"https:\/\/data-flair.training\/blogs\/qlikview-data-types\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-11-17T08:43:00+00:00","article_modified_time":"2021-12-07T05:50:16+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Dual-Data-Type-01.jpg","type":"image\/jpeg"}],"author":"DataFlair Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"DataFlair Team","Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/qlikview-data-types\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-data-types\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89"},"headline":"QlikView Data Types &#8211; Dual Data Format &amp; Interpretation, Representation","datePublished":"2018-11-17T08:43:00+00:00","dateModified":"2021-12-07T05:50:16+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-data-types\/"},"wordCount":1717,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-data-types\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Dual-Data-Type-01.jpg","keywords":["Data Interpretation","Data Types in QlikView","Date Interpretation","Dual Data Format","Modes of Representation","Numeric Interpretation","QlikView Data Types","Time Interpretation"],"articleSection":["QlikView Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/qlikview-data-types\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/qlikview-data-types\/","url":"https:\/\/data-flair.training\/blogs\/qlikview-data-types\/","name":"QlikView Data Types - Dual Data Format &amp; Interpretation, Representation - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-data-types\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-data-types\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Dual-Data-Type-01.jpg","datePublished":"2018-11-17T08:43:00+00:00","dateModified":"2021-12-07T05:50:16+00:00","description":"QlikView Data Types - What is Data Types in QlikView, QlikView Dual Data Format, Data Interpretation, Modes of Representation of Data in QlikView, Numeric","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-data-types\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/qlikview-data-types\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/qlikview-data-types\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Dual-Data-Type-01.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Dual-Data-Type-01.jpg","width":1200,"height":628,"caption":"QlikView Data Types - Dual Data Format &amp; Interpretation, Representation"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/qlikview-data-types\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"QlikView Tutorials","item":"https:\/\/data-flair.training\/blogs\/category\/qlikview\/"},{"@type":"ListItem","position":3,"name":"QlikView Data Types &#8211; Dual Data Format &amp; Interpretation, Representation"}]},{"@type":"WebSite","@id":"https:\/\/data-flair.training\/blogs\/#website","url":"https:\/\/data-flair.training\/blogs\/","name":"DataFlair","description":"Learn Today. Lead Tomorrow.","publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data-flair.training\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/data-flair.training\/blogs\/#organization","name":"DataFlair","url":"https:\/\/data-flair.training\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","width":106,"height":48,"caption":"DataFlair"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataFlairWS\/","https:\/\/x.com\/DataFlairWS","https:\/\/www.linkedin.com\/company\/dataflair-web-services-pvt-ltd\/","https:\/\/www.youtube.com\/user\/DataFlairWS"]},{"@type":"Person","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89","name":"DataFlair Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","caption":"DataFlair Team"},"description":"The DataFlair Team provides industry-driven content on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. Our expert educators focus on delivering value-packed, easy-to-follow resources for tech enthusiasts and professionals.","url":"https:\/\/data-flair.training\/blogs\/author\/dfteam2\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/38399","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=38399"}],"version-history":[{"count":9,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/38399\/revisions"}],"predecessor-version":[{"id":104953,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/38399\/revisions\/104953"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/38409"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=38399"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=38399"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=38399"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}