{"id":38425,"date":"2018-11-20T09:40:20","date_gmt":"2018-11-20T04:10:20","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=38425"},"modified":"2021-12-07T11:20:03","modified_gmt":"2021-12-07T05:50:03","slug":"qlikview-data-structure","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/qlikview-data-structure\/","title":{"rendered":"QlikView Data Structure &#8211; QlikView Table &amp; Fields"},"content":{"rendered":"<div class='__iawmlf-post-loop-links' style='display:none;' data-iawmlf-post-links='[{&quot;id&quot;:1728,&quot;href&quot;:&quot;https:\\\/\\\/help.qlik.com\\\/en-US\\\/qlikview\\\/November2017\\\/Subsystems\\\/Client\\\/Content\\\/LoadData\\\/understand-data-structures.htm&quot;,&quot;archived_href&quot;:&quot;http:\\\/\\\/web-wp.archive.org\\\/web\\\/20190627215638\\\/http:\\\/\\\/help.qlik.com:80\\\/en-US\\\/qlikview\\\/November2017\\\/Subsystems\\\/Client\\\/Content\\\/LoadData\\\/understand-data-structures.htm&quot;,&quot;redirect_href&quot;:&quot;&quot;,&quot;checks&quot;:[{&quot;date&quot;:&quot;2025-12-09 21:01:26&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2025-12-21 08:25:51&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-01-08 20:01:39&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-01-13 02:17:24&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-01-16 10:37:29&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-01-29 15:39:48&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-03-02 13:16:52&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-04-18 09:53:32&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-05-16 12:30:11&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-06-02 10:30:39&quot;,&quot;http_code&quot;:200}],&quot;broken&quot;:false,&quot;last_checked&quot;:{&quot;date&quot;:&quot;2026-06-02 10:30:39&quot;,&quot;http_code&quot;:200},&quot;process&quot;:&quot;done&quot;}]'><\/div>\n<p align=\"justify\"><span style=\"font-family: Arial, serif;font-size: medium\">In our last session, we talked about\u00a0<\/span><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-box-plot-wizard\/\"><strong>QlikView Box Plot Wizard<\/strong><\/a>. Today, we will understand the QlikView Data Structure. Moreover, we will learn QlikView Fields and QlikView Table Name and Labels. Along with this, we will study logical tables in QlikView.<\/p>\n<p align=\"justify\">So, let&#8217;s start the QlikView Data Structure Tutorial.<\/p>\n<div id=\"attachment_38442\" style=\"width: 1210px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Data-Structure-01.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-38442\" class=\"size-full wp-image-38442\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Data-Structure-01.jpg\" alt=\"QlikView Data Structure - QlikView Table &amp; Fields\" width=\"1200\" height=\"628\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Data-Structure-01.jpg 1200w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Data-Structure-01-150x79.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Data-Structure-01-300x157.jpg 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Data-Structure-01-768x402.jpg 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Data-Structure-01-1024x536.jpg 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Data-Structure-01-520x272.jpg 520w\" sizes=\"auto, (max-width: 1200px) 100vw, 1200px\" \/><\/a><p id=\"caption-attachment-38442\" class=\"wp-caption-text\">QlikView Data Structure &#8211; QlikView Table &amp; Fields<\/p><\/div>\n<h3 align=\"justify\">What is QlikView Data Structure?<\/h3>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">The <strong><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-data-load\/\">data loaded into QlikView<\/a><\/strong> from any type of file is stored in QlikView in a well-structured manner. The data is stored in tables whose structural arrangement makes data processing in QlikView significantly fast. There are different elements of the entire QlikView data structure which will discuss in the sections to come. <\/span><\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">It is very important for the data residing in QlikView to well-structured because if not, processing the information or data values for analysis and calculation becomes a tedious task and effects both speed and efficiency of the tool. <\/span><\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">Let us start our lesson from the very initial steps of loading data into QlikView. <\/span><\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">Data from any data source loaded using two script statements i.e. LOAD and SELECT which creates an internal table for and containing the data being loaded. A table is a combination of rows and columns where each <\/span><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\"><i>row (Record)<\/i><\/span><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\"> contains an object type and the <\/span><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\"><i>column (Field)<\/i><\/span><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\"> contains specific property or attributes of the object type.<\/span><\/span><\/span><\/p>\n<p align=\"justify\"><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-load-data-from-files\/\">Do you know how to load data from files in QlikView?<\/a><\/strong><\/p>\n<h4 align=\"justify\">a. Rule of Data Loading<\/h4>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">There is a certain set of rules defined for loading data into QlikView using LOAD and SELECT statements. <\/span><\/span><\/span><\/p>\n<ul>\n<li>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">The first rule is that the tables loaded using LOAD or SELECT or a mix of both doesn\u2019t pose a difference on the table being loaded. All the three ways of loading data are the same and tables loaded using them are also same. <\/span><\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">The second rule says that the order of fields both while loading in a statement and after being loaded in memory stays arbitrary. The order of fields does not set in a certain way. <\/span><\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">The field names (columns) of tables loaded into QlikView\u2019s memory are case-sensitive and are used for data associations or in functions in the script. <\/span><\/span><\/span><\/p>\n<\/li>\n<\/ul>\n<h4 align=\"justify\">b. Script Execution<\/h4>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">The order of events taking place during the execution of a <strong><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-scripting\/\">script<\/a><\/strong> in which tables are being loaded using LOAD and SELECT statements represent below. <\/span><\/span><\/span><\/p>\n<div id=\"attachment_38437\" style=\"width: 510px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Script-Execution-01.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-38437\" class=\"size-full wp-image-38437\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Script-Execution-01.jpg\" alt=\"QlikView Data Structure - QlikView Table &amp; Fields\" width=\"500\" height=\"500\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Script-Execution-01.jpg 500w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Script-Execution-01-150x150.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Script-Execution-01-300x300.jpg 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Script-Execution-01-160x160.jpg 160w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Script-Execution-01-320x320.jpg 320w\" sizes=\"auto, (max-width: 500px) 100vw, 500px\" \/><\/a><p id=\"caption-attachment-38437\" class=\"wp-caption-text\">QlikView Data Structure &#8211; QlikView Script Execution<\/p><\/div>\n<h3 style=\"text-align: left\" align=\"center\">QlikView Fields<\/h3>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">Fields are the most important entities in a table. The QlikView field is known to be the data-carrying entities because it is in respective fields that all the data values corresponding to that field reside. When we talk about loading or extracting data from the data file, the data contained as data values in data fields actually get retrieved. <\/span><\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">Like the rows and columns in a table, records and fields are in a QlikView table respectively. An information contained in a data field may sort in any number of fields as per the requirement. As we know, the file data can extract using LOAD and SELECT statements or even the Binary statement in some cases.<\/span><\/span><\/span><\/p>\n<p align=\"justify\"><strong><a href=\"https:\/\/data-flair.training\/blogs\/loading-data-from-database-in-qlikview\/\">Follow this link to know loading data from database in QlikView<\/a><\/strong><\/p>\n<div id=\"attachment_38443\" style=\"width: 1210px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Fields-01.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-38443\" class=\"size-full wp-image-38443\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Fields-01.jpg\" alt=\"QlikView Data Structure - QlikView Fields\" width=\"1200\" height=\"628\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Fields-01.jpg 1200w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Fields-01-150x79.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Fields-01-300x157.jpg 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Fields-01-768x402.jpg 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Fields-01-1024x536.jpg 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Fields-01-520x272.jpg 520w\" sizes=\"auto, (max-width: 1200px) 100vw, 1200px\" \/><\/a><p id=\"caption-attachment-38443\" class=\"wp-caption-text\">QlikView Data Structure &#8211; QlikView Fields<\/p><\/div>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\"> In QlikView, the data once loaded structured as field and records cannot manipulate when they are displayed at the front end as sheet objects by the user. Any changes that the user wishes to bring in the table and its filed can only be done through the script and then reloading or re-executing the script. The field values have strings, numeric or alphanumeric data types which exist in the dual format so that they can use in calculations and sorting in future.<\/span><\/span><\/span><\/p>\n<p lang=\"en-US\" align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">A detailed information about the loaded tables and their field structure view from the <\/span><\/span><\/span><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-table\/\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\"><b>Tables<\/b><\/span><\/span><\/span><\/a><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\"> tab in <\/span><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">the<a href=\"https:\/\/data-flair.training\/blogs\/qlikview-documents\/\"><b> Document Properties<\/b><\/a><\/span><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\"> dialog box in QlikView. It can invoke from the Settings menu or by pressing <\/span><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\"><b>Ctrl+Alt+D<\/b><\/span><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">. It gives information like table list, number of fields (columns), number of records (rows). You can select\/deselect the fields you want to define as Dimensions or Measures. Also, you can export an existing data structure if you want. <\/span><\/span><\/span><\/p>\n<div id=\"attachment_38430\" style=\"width: 948px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/dstruc2.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-38430\" class=\"size-full wp-image-38430\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/dstruc2.png\" alt=\"QlikView Data Structure - QlikView Fields\" width=\"938\" height=\"759\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/dstruc2.png 938w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/dstruc2-150x121.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/dstruc2-300x243.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/dstruc2-768x621.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/dstruc2-520x421.png 520w\" sizes=\"auto, (max-width: 938px) 100vw, 938px\" \/><\/a><p id=\"caption-attachment-38430\" class=\"wp-caption-text\">QlikView Data Structure &#8211; QlikView Fields<\/p><\/div>\n<h4 align=\"justify\">a. QlikView Field Tags<\/h4>\n<p align=\"justify\"><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">In QlikView, field tags use to add metadata to already existing fields. You can add either System field tags or Custom filed tags in QlikView. The prefix to system tags is \u2018$\u2019 and they generate automatically during script execution by the system. On the other hand, custom field tags can create using <\/span><\/span><\/span><\/span><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\"><b>Tag <\/b><\/span><\/span><\/span><\/span><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">statement by the user in the script. <\/span><\/span><\/span><\/span><\/p>\n<table width=\"620\">\n<colgroup>\n<col width=\"117\" \/>\n<col width=\"307\" \/>\n<col width=\"152\" \/> <\/colgroup>\n<tbody>\n<tr>\n<td style=\"background: #a5a5a5\" width=\"117\" height=\"5\">\n<p align=\"justify\"><b><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">Tag<\/span><\/span><\/span><\/span><\/b><\/p>\n<\/td>\n<td style=\"background: #a5a5a5\" width=\"307\">\n<p align=\"justify\"><b><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">Description<\/span><\/span><\/span><\/span><\/b><\/p>\n<\/td>\n<td style=\"background: #a5a5a5\" width=\"152\">\n<p align=\"justify\"><b><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">Script Manipulation<\/span><\/span><\/span><\/span><\/b><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"background: #ededed\" width=\"117\" height=\"6\">\n<p align=\"justify\"><b><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">$system<\/span><\/span><\/span><\/span><\/b><\/p>\n<\/td>\n<td style=\"background: #ededed\" width=\"307\">\n<p align=\"justify\"><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">QlikView generated system filed<\/span><\/span><\/span><\/p>\n<\/td>\n<td style=\"background: #ededed\" width=\"152\">\n<p align=\"justify\"><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">No<\/span><\/span><\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"117\" height=\"5\">\n<p align=\"justify\"><b><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">$key<\/span><\/span><\/span><\/span><\/b><\/p>\n<\/td>\n<td width=\"307\">\n<p align=\"justify\"><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">A key field linking two or more tables<\/span><\/span><\/span><\/span><\/p>\n<\/td>\n<td width=\"152\">\n<p align=\"justify\"><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">No<\/span><\/span><\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"background: #ededed\" width=\"117\" height=\"6\">\n<p align=\"justify\"><b><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">$keypart<\/span><\/span><\/span><\/span><\/b><\/p>\n<\/td>\n<td style=\"background: #ededed\" width=\"307\">\n<p align=\"justify\"><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">Part of one or more synthetic keys<\/span><\/span><\/span><\/span><\/p>\n<\/td>\n<td style=\"background: #ededed\" width=\"152\">\n<p align=\"justify\"><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">No<\/span><\/span><\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"117\" height=\"6\">\n<p align=\"justify\"><b><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">$syn<\/span><\/span><\/span><\/span><\/b><\/p>\n<\/td>\n<td width=\"307\">\n<p align=\"justify\"><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">The field for a synthetic key<\/span><\/span><\/span><\/span><\/p>\n<\/td>\n<td width=\"152\">\n<p align=\"justify\"><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">No<\/span><\/span><\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"background: #ededed\" width=\"117\" height=\"6\">\n<p align=\"justify\"><b><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">$hidden<\/span><\/span><\/span><\/span><\/b><\/p>\n<\/td>\n<td style=\"background: #ededed\" width=\"307\">\n<p align=\"justify\"><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">These fields are hidden and can only use through expression variables like <\/span><\/span><\/span><\/span><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\"><b>HidePrefix<\/b><\/span><\/span><\/span><\/span><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\"> and <\/span><\/span><\/span><\/span><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\"><b>HideSuffix<\/b><\/span><\/span><\/span><\/span><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\"> in the script.<\/span><\/span><\/span><\/span><\/p>\n<\/td>\n<td style=\"background: #ededed\" width=\"152\">\n<p align=\"justify\"><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">Yes<\/span><\/span><\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"117\" height=\"6\">\n<p align=\"justify\"><b><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">$numeric<\/span><\/span><\/span><\/span><\/b><\/p>\n<\/td>\n<td width=\"307\">\n<p align=\"justify\"><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">All field values in a table are numeric (except for NULL)<\/span><\/span><\/span><\/span><\/p>\n<\/td>\n<td width=\"152\">\n<p align=\"justify\"><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">Yes<\/span><\/span><\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"background: #ededed\" width=\"117\" height=\"6\">\n<p align=\"justify\"><b><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">$integer<\/span><\/span><\/span><\/span><\/b><\/p>\n<\/td>\n<td style=\"background: #ededed\" width=\"307\">\n<p align=\"justify\"><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">All field values are integers (except for NULL values)<\/span><\/span><\/span><\/span><\/p>\n<\/td>\n<td style=\"background: #ededed\" width=\"152\">\n<p align=\"justify\"><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">Yes<\/span><\/span><\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"117\" height=\"5\">\n<p align=\"justify\"><b><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">$text<\/span><\/span><\/span><\/span><\/b><\/p>\n<\/td>\n<td width=\"307\">\n<p align=\"justify\"><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">All fields except for numeric<\/span><\/span><\/span><\/span><\/p>\n<\/td>\n<td width=\"152\">\n<p align=\"justify\"><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">Yes<\/span><\/span><\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"background: #ededed\" width=\"117\" height=\"6\">\n<p align=\"justify\"><b><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">$ascii<\/span><\/span><\/span><\/span><\/b><\/p>\n<\/td>\n<td style=\"background: #ededed\" width=\"307\">\n<p align=\"justify\"><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">Field values containing only standard ASCII characters<\/span><\/span><\/span><\/span><\/p>\n<\/td>\n<td style=\"background: #ededed\" width=\"152\">\n<p align=\"justify\"><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">Yes<\/span><\/span><\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"117\" height=\"6\">\n<p align=\"justify\"><b><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">$date<\/span><\/span><\/span><\/span><\/b><\/p>\n<\/td>\n<td width=\"307\">\n<p align=\"justify\"><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">All field values except for NULL values can interpret as dates.<\/span><\/span><\/span><\/span><\/p>\n<\/td>\n<td width=\"152\">\n<p align=\"justify\"><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">Yes<\/span><\/span><\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"background: #ededed\" width=\"117\" height=\"5\">\n<p align=\"justify\"><b><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">$timestamp<\/span><\/span><\/span><\/span><\/b><\/p>\n<\/td>\n<td style=\"background: #ededed\" width=\"307\">\n<p align=\"justify\"><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">All field values except for NULL values can interpret as a timestamp (date and time)<\/span><\/span><\/span><\/span><\/p>\n<\/td>\n<td style=\"background: #ededed\" width=\"152\">\n<p align=\"justify\"><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">Yes<\/span><\/span><\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4 align=\"justify\">b. System Fields in Qlikview<\/h4>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">Apart from the QlikView fields generate to structure data extract\u00a0from external sources, QlikView also generates some fields during script execution known as System Fields. These QlikView fields not used by the user but kept by the system as a structure and design aid. As we saw in the previous section, system fields also prefixed by the sign \u2018$\u2019.<\/span><\/span><\/span><\/p>\n<p align=\"justify\"><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-dollar-sign-expansion\/\">Let&#8217;s revise Dollar Sign Expansion in QlikView<\/a><\/strong><\/p>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">You can view these system fields by right-clicking anywhere on the sheet. Then click on <\/span><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\"><b>Select Fields\u2026<\/b><\/span><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\"> , a dialog will open whereupon checking the <\/span><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\"><b>Show System Fields<\/b><\/span><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\"> option all the system fields will display. <\/span><\/span><\/span><\/p>\n<div id=\"attachment_38431\" style=\"width: 269px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/dstruc3.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-38431\" class=\"size-full wp-image-38431\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/dstruc3.png\" alt=\"QlikView Data Structure - System Fields \" width=\"259\" height=\"329\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/dstruc3.png 259w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/dstruc3-118x150.png 118w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/dstruc3-236x300.png 236w\" sizes=\"auto, (max-width: 259px) 100vw, 259px\" \/><\/a><p id=\"caption-attachment-38431\" class=\"wp-caption-text\">QlikView Data Structure &#8211; System Fields<\/p><\/div>\n<div id=\"attachment_38432\" style=\"width: 848px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/dstruc4.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-38432\" class=\"size-full wp-image-38432\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/dstruc4.png\" alt=\"QlikView Data Structure - System Fields \" width=\"838\" height=\"648\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/dstruc4.png 838w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/dstruc4-150x116.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/dstruc4-300x232.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/dstruc4-768x594.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/dstruc4-520x402.png 520w\" sizes=\"auto, (max-width: 838px) 100vw, 838px\" \/><\/a><p id=\"caption-attachment-38432\" class=\"wp-caption-text\">QlikView Data Structure &#8211; System Fields<\/p><\/div>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">The table given below has a brief description of the common system fields displayed.<\/span><\/span><\/span><\/p>\n<ul>\n<li>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\"><b>$Table<\/b><\/span><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">: Displays all internal tables loaded during executing the script.<\/span><\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\"><b>$Field<\/b><\/span><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">: Displays all the fields that are read from the tables. <\/span><\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\"><b>$Fields<\/b><\/span><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">: Shows the number of fields in different tables.<\/span><\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\"><b>$FieIdNo<\/b><\/span><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">: Shows the position of the fields in the tables.<\/span><\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\"><b>$Rows<\/b><\/span><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">: Shows the number of rows in the tables.<\/span><\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\"><b>$Info<\/b><\/span><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">: Displays the names of the info tables if included in the document. <\/span><\/span><\/span><\/p>\n<\/li>\n<\/ul>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">Also, a System Table can generate that shows all the details of the available table in that document and their Dimensions and Measures. It can create through selecting <\/span><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\"><b>Layout&gt;New Sheet Object&gt; System Table.<\/b><\/span><\/span><\/span><\/p>\n<div id=\"attachment_38433\" style=\"width: 522px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/dstruc6.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-38433\" class=\"size-full wp-image-38433\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/dstruc6.png\" alt=\"QlikView Data Structure - System Fields \" width=\"512\" height=\"521\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/dstruc6.png 512w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/dstruc6-147x150.png 147w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/dstruc6-295x300.png 295w\" sizes=\"auto, (max-width: 512px) 100vw, 512px\" \/><\/a><p id=\"caption-attachment-38433\" class=\"wp-caption-text\">QlikView Data Structure &#8211; System Fields<\/p><\/div>\n<div id=\"attachment_38434\" style=\"width: 498px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/dstruc7.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-38434\" class=\"size-full wp-image-38434\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/dstruc7.png\" alt=\"QlikView Data Structure - System Fields \" width=\"488\" height=\"193\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/dstruc7.png 488w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/dstruc7-150x59.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/dstruc7-300x119.png 300w\" sizes=\"auto, (max-width: 488px) 100vw, 488px\" \/><\/a><p id=\"caption-attachment-38434\" class=\"wp-caption-text\">QlikView Data Structure &#8211; System Fields<\/p><\/div>\n<h4 align=\"justify\">c. Input Fields<\/h4>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">As we know that in QlikView, data field values cannot edit in the sheet objects like a table box, chart, list box etc. It can only edit either at the source or in the script. However, there is a feature or a script statement rather, that allows you to edit the data values in the sheet objects. This feature is called the INPUTFIELD statement. <\/span><\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">You have to define the table fields which you want to keep in input edit mode using this statement before defining the LOAD statement. One thing to keep in mind is that this feature is not applicable on the key fields. <\/span><\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">Once you reload the script using the Inputfield statement you will see input icons in front of each field value in the selected field. Upon clicking on this icon, the value or matter of that cell can change. You can also associate an expression so that the values you enter gets evaluated according to that expression condition.<\/span><\/span><\/span><\/p>\n<p align=\"justify\"><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-distribution-service\/\">Have a look &#8211; QlikView Distributed Service<\/a><\/strong><\/p>\n<p lang=\"en-US\" align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">Let us see how the input field works with the help of an example. <\/span><\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">Suppose we have some data related to selling price and quantities of the product sold (refer to the image below).<\/span><\/span><\/span><\/p>\n<div id=\"attachment_42848\" style=\"width: 1322px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/dstruc8.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-42848\" class=\"size-full wp-image-42848\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/dstruc8.jpg\" alt=\"QlikView Data Structure - Example\" width=\"1312\" height=\"399\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/dstruc8.jpg 1312w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/dstruc8-150x46.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/dstruc8-300x91.jpg 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/dstruc8-768x234.jpg 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/dstruc8-1024x311.jpg 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/dstruc8-520x158.jpg 520w\" sizes=\"auto, (max-width: 1312px) 100vw, 1312px\" \/><\/a><p id=\"caption-attachment-42848\" class=\"wp-caption-text\">QlikView Data Structure &#8211; Example<\/p><\/div>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">Now we need to input the values in the field Input price and calculate the changes occurring through the changed price in final sales amount. We will do so by making the field \u2018Input Price\u2019 an input field. This will do with the INPUTFIELD statement. Save the changes in the script and reload the script (Ctrl+R).<\/span><\/span><\/span><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">\/\/FROM\r\n\/\/[C:\\User\\Qlikpower\\Download\\qv dummy cube.xlsx]\r\n\/\/ (ooxml, embedded labels, table is Sheet1);\r\n\r\nINPUTFIELD [Input Price];\r\nLOAD [Product Code],\r\n     [Selling Price],\r\n     [Input Price],\r\n     Quantity\r\nFROM\r\n[C:\\User\\QlikPower\\Desktop\\Price List.xls]\r\n(biff, embedded labels, table is Sheet1$);<\/pre>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/dstruc9.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-42849 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/dstruc9.jpg\" alt=\"QlikView Data Structure - Script\" width=\"730\" height=\"396\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/dstruc9.jpg 730w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/dstruc9-150x81.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/dstruc9-300x163.jpg 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/dstruc9-520x282.jpg 520w\" sizes=\"auto, (max-width: 730px) 100vw, 730px\" \/><\/a><\/p>\n<p>QlikView Data Structure &#8211; Script<\/p>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">An input function InputSum can apply on the Input Price field. So that it can carry out some calculations.<\/span><\/span><\/span><\/p>\n<div id=\"attachment_42850\" style=\"width: 586px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/dstruc10.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-42850\" class=\"size-full wp-image-42850\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/dstruc10.jpg\" alt=\"QlikView Data Structure \" width=\"576\" height=\"510\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/dstruc10.jpg 576w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/dstruc10-150x133.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/dstruc10-300x266.jpg 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/dstruc10-520x460.jpg 520w\" sizes=\"auto, (max-width: 576px) 100vw, 576px\" \/><\/a><p id=\"caption-attachment-42850\" class=\"wp-caption-text\">QlikView Data Structure &#8211; Input price field<\/p><\/div>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">Now, in the table, the input mode has been activated in the selected field. You can edit the cells using the input icons. <\/span><\/span><\/span><\/p>\n<div id=\"attachment_42851\" style=\"width: 1319px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/dstruc11.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-42851\" class=\"size-full wp-image-42851\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/dstruc11.jpg\" alt=\"QlikView Data Structure \" width=\"1309\" height=\"396\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/dstruc11.jpg 1309w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/dstruc11-150x45.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/dstruc11-300x91.jpg 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/dstruc11-768x232.jpg 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/dstruc11-1024x310.jpg 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/dstruc11-520x157.jpg 520w\" sizes=\"auto, (max-width: 1309px) 100vw, 1309px\" \/><\/a><p id=\"caption-attachment-42851\" class=\"wp-caption-text\">QlikView Data Structure &#8211; Selection field<\/p><\/div>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">In the sample data, when input price values have been entered and the other values like \u2018price difference\u2019 and \u2018sales amount after price change\u2019 are recalculated and displayed. <\/span><\/span><\/span><\/p>\n<div id=\"attachment_42852\" style=\"width: 824px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/dstruc12.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-42852\" class=\"size-full wp-image-42852\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/dstruc12.jpg\" alt=\"QlikView Data Structure \" width=\"814\" height=\"247\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/dstruc12.jpg 814w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/dstruc12-150x46.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/dstruc12-300x91.jpg 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/dstruc12-768x233.jpg 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/dstruc12-520x158.jpg 520w\" sizes=\"auto, (max-width: 814px) 100vw, 814px\" \/><\/a><p id=\"caption-attachment-42852\" class=\"wp-caption-text\">QlikView Data Structure &#8211; Sample Data<\/p><\/div>\n<h3 align=\"justify\">QlikView Table Names and Labels<\/h3>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">When a table is loaded in QlikView from a data source, the table can name using labels or other naming methods in the script. The tables can label in the script in the way given below,<\/span><\/span><\/span><\/p>\n<p lang=\"en-US\" align=\"justify\"><span style=\"font-family: Courier New, serif\"><span style=\"font-size: large\"><span lang=\"en-US\">Table1:<\/span><\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Courier New, serif\"><span style=\"font-size: large\"><span lang=\"en-US\">LOAD a,b from c.csv;<\/span><\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Courier New, serif\"><span style=\"font-size: large\"><span lang=\"en-US\">LOAD x,y from d.csv where x=peek(&#8216;a&#8217;,y,&#8217;Table1&#8242;);<\/span><\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">Here, the table will name as Table1 by writing \u2018Table1:\u2019 at the start. <\/span><\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">If the user does not mention a label, then the file name from the source file take mention in the From statement. <\/span><\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">In case of Inline tables, the labels generate as INLINExx where xx is the serial number in the order the tables create. Like the first table has INLINE01, for the second table, it will INLINE02. <\/span><\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">Similarly, tables generated using <strong><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-autogenerate\/\">Autogenerate<\/a><\/strong> are named as per the format AUTOGENERATExx. Like, AUTOGENERATE01 and so on. <\/span><\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">If some name repeats, then one of them named by the adding the suffix \u2018-x\u2019. For example. Sales-1, Sales-2 etc.<\/span><\/span><\/span><\/p>\n<h3 align=\"justify\">Logical Tables in QlikView<\/h3>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">Logical Tables are the tables that follow a certain logic that defines how the data values and fields will behave and get associated with other fields in other tables. Every table loaded in QlikView will be one or the other type of a logical table. <\/span><\/span><\/span><\/p>\n<table dir=\"ltr\">\n<colgroup>\n<col width=\"245\" \/>\n<col width=\"246\" \/><\/colgroup>\n<tbody>\n<tr>\n<td><strong>Table Type<\/strong><\/td>\n<td><strong>Description<\/strong><\/td>\n<\/tr>\n<tr>\n<td><strong>Concatenate<\/strong><\/td>\n<td>\n<div>\n<div>Two tables join keeps the data records of each, intact.<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<tr>\n<td><strong>Crosstable<\/strong><\/td>\n<td>\n<div>\n<div>Create by changing the orientation of rows and columns in a standard table.<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<tr>\n<td><strong>Generic<\/strong><\/td>\n<td>\n<div>\n<div>Such tables make by splitting one table into several different logical tables.<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<tr>\n<td><strong>Info<\/strong><\/td>\n<td>\n<div>\n<div>Such tables contain information about external sources like files, sounds, URLs etc, hence, they call as information tables.<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<tr>\n<td><strong>Intervalmatch<\/strong><\/td>\n<td>\n<div>\n<div>Creates by interpreting numeric intervals present in the fields or columns of other tables.<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<tr>\n<td><strong>Join<\/strong><\/td>\n<td>\n<div>\n<div>A table creates joining previously loaded or pre-existing tables in QlikView.<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<tr>\n<td><strong>Keep<\/strong><\/td>\n<td>\n<div>\n<div>A table creates having only the common fields between two or more tables.<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<tr>\n<td><strong>Mapping<\/strong><\/td>\n<td>\n<div>\n<div>Creates a copy or maps already existing fields in a new table.<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<tr>\n<td><strong>Semantics<\/strong><\/td>\n<td>Such tables store the information on the relations between different tables such as predecessor, successor etc. Such tables\u00a0call as semantics tables.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<div align=\"right\"><\/div>\n<h3 align=\"justify\">Optimal Data Structure in QlikView<\/h3>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">In QlikView, although the system manages the data being loaded into QlikView in terms of its structure and layout, there are still certain practices the users need to follow to ensure optimal functioning of the software.<\/span><\/span><\/span><\/p>\n<p align=\"justify\"><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-keep-functions\/\">Do you know what is QlikView Keep Functions?<\/a><\/strong><\/p>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">If the tables do not link and structure properly, then the consequences will see by the inefficient working of QlikView. If the QlikView data structure is in the form of a snowflake, then it will pose many difficulties in processing the data and tracking associations of data values between multiple tables. QlikView Data structured in the snowflake design shows below. <\/span><\/span><\/span><\/p>\n<div id=\"attachment_42853\" style=\"width: 1064px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/dstruc14.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-42853\" class=\"size-full wp-image-42853\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/dstruc14.jpg\" alt=\"QlikView Data Structure \" width=\"1054\" height=\"492\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/dstruc14.jpg 1054w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/dstruc14-150x70.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/dstruc14-300x140.jpg 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/dstruc14-768x358.jpg 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/dstruc14-1024x478.jpg 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/dstruc14-520x243.jpg 520w\" sizes=\"auto, (max-width: 1054px) 100vw, 1054px\" \/><\/a><p id=\"caption-attachment-42853\" class=\"wp-caption-text\">Optimal QlikView Data Structure<\/p><\/div>\n<p lang=\"en-US\" align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">Instead of data being in a\u00a0snowflake structure, it should structure as the star schema. <\/span><\/span><\/span><\/p>\n<div id=\"attachment_42854\" style=\"width: 670px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/dstruc15.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-42854\" class=\"size-full wp-image-42854\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/dstruc15.jpg\" alt=\"QlikView Data Structure \" width=\"660\" height=\"575\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/dstruc15.jpg 660w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/dstruc15-150x131.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/dstruc15-300x261.jpg 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/dstruc15-520x453.jpg 520w\" sizes=\"auto, (max-width: 660px) 100vw, 660px\" \/><\/a><p id=\"caption-attachment-42854\" class=\"wp-caption-text\">Optimal QlikView Data Structure as Star Schema<\/p><\/div>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">Also, for QlikView data structure optimization, a formation of synthetic keys must avoid. Synthetic keys create when there are one or more common fields between two or more tables.<\/span><\/span><\/span><\/p>\n<p align=\"justify\">So, this was all about QlikView Data Structure Tutorial. Hope you like our explanation.<\/p>\n<h2 align=\"justify\">Conclusion<\/h2>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">Hence, in this lesson, we learned about the basics of QlikView data structure and topics related to it. We saw the rules of data loading, a process of script execution, about two different types of fields, field tags, naming tables, logical tables and at last, how to optimize data structure in QlikView. Furthermore, if you have any query, feel free to ask in the comment box.<\/span><\/span><\/span><\/p>\n<p align=\"justify\">Related Topic &#8211; <strong><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-master-calendar\/\">QlikView Master Calendar<\/a><\/strong><\/p>\n<p align=\"justify\"><strong><a href=\"https:\/\/help.qlik.com\/en-US\/qlikview\/November2017\/Subsystems\/Client\/Content\/LoadData\/understand-data-structures.htm\">Reference<\/a><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In our last session, we talked about\u00a0QlikView Box Plot Wizard. Today, we will understand the QlikView Data Structure. Moreover, we will learn QlikView Fields and QlikView Table Name and Labels. Along with this, we&#46;&#46;&#46;<\/p>\n","protected":false},"author":6,"featured_media":38442,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[47],"tags":[17226,17230,17234,17227,17229,17231,17232,17233,17228],"class_list":["post-38425","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-qlikview","tag-data-structure-in-qlikview","tag-fields-in-qlikview","tag-logical-tables-in-qlikview","tag-optimal-data-structure-in-qlikview","tag-qlikview-fields","tag-qlikview-table","tag-qlikview-table-names","tag-qlikview-table-names-and-labels","tag-what-is-qlikview-data-structure"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>QlikView Data Structure - QlikView Table &amp; Fields - DataFlair<\/title>\n<meta name=\"description\" content=\"What is QlikView Data Structure-Optimal Data Structure,QlikView Fields Tages,System Field,QlikView Table Name &amp; Lables,Script Execution,Role of Data Loading\" \/>\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-structure\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"QlikView Data Structure - QlikView Table &amp; Fields - DataFlair\" \/>\n<meta property=\"og:description\" content=\"What is QlikView Data Structure-Optimal Data Structure,QlikView Fields Tages,System Field,QlikView Table Name &amp; Lables,Script Execution,Role of Data Loading\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/qlikview-data-structure\/\" \/>\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-20T04:10:20+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-12-07T05:50:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Data-Structure-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=\"13 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"QlikView Data Structure - QlikView Table &amp; Fields - DataFlair","description":"What is QlikView Data Structure-Optimal Data Structure,QlikView Fields Tages,System Field,QlikView Table Name & Lables,Script Execution,Role of Data Loading","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-structure\/","og_locale":"en_US","og_type":"article","og_title":"QlikView Data Structure - QlikView Table &amp; Fields - DataFlair","og_description":"What is QlikView Data Structure-Optimal Data Structure,QlikView Fields Tages,System Field,QlikView Table Name & Lables,Script Execution,Role of Data Loading","og_url":"https:\/\/data-flair.training\/blogs\/qlikview-data-structure\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-11-20T04:10:20+00:00","article_modified_time":"2021-12-07T05:50:03+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Data-Structure-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":"13 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/qlikview-data-structure\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-data-structure\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89"},"headline":"QlikView Data Structure &#8211; QlikView Table &amp; Fields","datePublished":"2018-11-20T04:10:20+00:00","dateModified":"2021-12-07T05:50:03+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-data-structure\/"},"wordCount":2200,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-data-structure\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Data-Structure-01.jpg","keywords":["Data Structure in QlikView","Fields in QlikView","Logical Tables in QlikView","Optimal Data Structure in QlikView","QlikView Fields","QlikView Table","QlikView Table Names","QlikView Table Names and Labels","What is QlikView Data Structure"],"articleSection":["QlikView Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/qlikview-data-structure\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/qlikview-data-structure\/","url":"https:\/\/data-flair.training\/blogs\/qlikview-data-structure\/","name":"QlikView Data Structure - QlikView Table &amp; Fields - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-data-structure\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-data-structure\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Data-Structure-01.jpg","datePublished":"2018-11-20T04:10:20+00:00","dateModified":"2021-12-07T05:50:03+00:00","description":"What is QlikView Data Structure-Optimal Data Structure,QlikView Fields Tages,System Field,QlikView Table Name & Lables,Script Execution,Role of Data Loading","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-data-structure\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/qlikview-data-structure\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/qlikview-data-structure\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Data-Structure-01.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Data-Structure-01.jpg","width":1200,"height":628,"caption":"QlikView Data Structure - QlikView Table &amp; Fields"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/qlikview-data-structure\/#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 Structure &#8211; QlikView Table &amp; Fields"}]},{"@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\/38425","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=38425"}],"version-history":[{"count":12,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/38425\/revisions"}],"predecessor-version":[{"id":104941,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/38425\/revisions\/104941"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/38442"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=38425"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=38425"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=38425"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}