

{"id":27467,"date":"2018-09-07T03:30:22","date_gmt":"2018-09-07T03:30:22","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=27467"},"modified":"2021-12-07T11:24:50","modified_gmt":"2021-12-07T05:54:50","slug":"qlikview-table","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/qlikview-table\/","title":{"rendered":"QlikView Table &#8211; Creating Cross, Straight, Pivot, Mapping Tables"},"content":{"rendered":"<p>In our last session, we discussed <a href=\"https:\/\/data-flair.training\/blogs\/qlikview-autogenerate\/\"><strong>QlikView Autogenerate<\/strong><\/a>. Now, in this QlikView Table Tutorial, we are going to learn how to create: QlikView\u00a0Cross Table, QlikView Straight Table, QlikView Pivot Table, and\u00a0QlikView Mapping Table with an example.<\/p>\n<p>So, let&#8217;s start\u00a0the <a href=\"https:\/\/data-flair.training\/blogs\/business-intelligence\/\"><strong>QlikView<\/strong><\/a> Table Tutorial.<\/p>\n<div id=\"attachment_27482\" style=\"width: 1210px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/QlikView-Tables-01.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-27482\" class=\"wp-image-27482 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/QlikView-Tables-01.jpg\" alt=\"QlikView Table - Creating Cross, Straight, Pivot, Mapping Tables\" width=\"1200\" height=\"628\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/QlikView-Tables-01.jpg 1200w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/QlikView-Tables-01-150x79.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/QlikView-Tables-01-300x157.jpg 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/QlikView-Tables-01-768x402.jpg 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/QlikView-Tables-01-1024x536.jpg 1024w\" sizes=\"auto, (max-width: 1200px) 100vw, 1200px\" \/><\/a><p id=\"caption-attachment-27482\" class=\"wp-caption-text\">QlikView Table &#8211; Creating Cross, Straight, Pivot, Mapping Tables<\/p><\/div>\n<h3>What is QlikView Table?<\/h3>\n<p>The most preferred way of representing data is in the form of a table. Apart from sheet object Table Box, which is a basic tabular representation of data. There are 4 types of QlikView table: pivot table, cross table, straight table and a mapping table. Such QlikView table enables data representation in their unique ways.<\/p>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-dimensions-measures\/\">Do you know about How to Use QlikView Dimensions and Measures?<\/a><\/strong><\/p>\n<h3>QlikView Cross Table<\/h3>\n<p><em>QlikView Cross Table<\/em> is a table where the rows and column switch places. We have already seen this type of action in transformation wizard called Transpose but such tables are a bit different from that. In a cross table, the values of rows repeat themselves for each column value. A cross table can be created in File Wizard.<\/p>\n<p><strong>a. How to create a cross table in Qlikview with an example?<\/strong><\/p>\n<p>Load the data file in Qlikview\u2019s memory. Here given is the data of four different salespersons and the sales done by them in three regions.<\/p>\n<pre class=\"EnlighterJSRAW\">Salesperson,Region1,Region2,Region3\r\nS1,435,856,730\r\nS2,780,650,715\r\nS3,380,520,490\r\nS4,550,640,765<\/pre>\n<p>After opening the delimited file in the file wizard click on NEXT to carry further.<\/p>\n<div id=\"attachment_27484\" style=\"width: 749px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/cross1.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-27484\" class=\"wp-image-27484 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/cross1.png\" alt=\"QlikView Table - QlikView Cross Table\" width=\"739\" height=\"549\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/cross1.png 739w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/cross1-150x111.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/cross1-300x223.png 300w\" sizes=\"auto, (max-width: 739px) 100vw, 739px\" \/><\/a><p id=\"caption-attachment-27484\" class=\"wp-caption-text\">Step.1 QlikView Table &#8211; QlikView Cross Table<\/p><\/div>\n<p>Enable the Transformation Wizard. Click on Next.<\/p>\n<p>Now, you will see the file wizard window with an option of CROSSTABL Click on it. You will see the table columns highlighted in different colours.<\/p>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-dashboard\/\">Follow this link to know How to Create QlikView Dashboard.<\/a><\/strong><\/p>\n<p>Below you can make selections of parameters like a Qualifier field, which will be repeated with each value of the columns.<br \/>\nNext is Attribute Field, which will contain the different values of columns. The values in the attribute field are typed as data.<\/p>\n<div id=\"attachment_27485\" style=\"width: 911px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/cross2.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-27485\" class=\"wp-image-27485 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/cross2.png\" alt=\"QlikView Table - QlikView Cross Table\" width=\"901\" height=\"653\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/cross2.png 901w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/cross2-150x109.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/cross2-300x217.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/cross2-768x557.png 768w\" sizes=\"auto, (max-width: 901px) 100vw, 901px\" \/><\/a><p id=\"caption-attachment-27485\" class=\"wp-caption-text\">Step.2 QlikView Table &#8211; QlikView Cross Table<\/p><\/div>\n<p>Click OK and the FINISH in the next window.<\/p>\n<div id=\"attachment_27494\" style=\"width: 754px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/QlikView-cross-03-1.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-27494\" class=\"wp-image-27494 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/QlikView-cross-03-1.png\" alt=\"QlikView Table - QlikView Cross Table\" width=\"744\" height=\"661\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/QlikView-cross-03-1.png 744w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/QlikView-cross-03-1-150x133.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/QlikView-cross-03-1-300x267.png 300w\" sizes=\"auto, (max-width: 744px) 100vw, 744px\" \/><\/a><p id=\"caption-attachment-27494\" class=\"wp-caption-text\">Step.3 QlikView Table &#8211; QlikView Cross Table<\/p><\/div>\n<p>The script will be automatically loaded. Save it and reload it on the sheet.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">CrossTable (Regional, Data)\r\nLOAD Salesperson,\r\n      Regional1,\r\n      Regional2,\r\n      Regional3\r\nFROM\r\n[C:\\Users\\HP\\Desktop\\Dataflair\\crosstable.csv]\r\n(txt, codepage is 1252, embedded labels, delimiter is ',', msq);<\/pre>\n<div id=\"attachment_27495\" style=\"width: 825px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/cross4-2.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-27495\" class=\"wp-image-27495 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/cross4-2.png\" alt=\"QlikView Table - QlikView Cross Table\" width=\"815\" height=\"973\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/cross4-2.png 815w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/cross4-2-126x150.png 126w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/cross4-2-251x300.png 251w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/cross4-2-768x917.png 768w\" sizes=\"auto, (max-width: 815px) 100vw, 815px\" \/><\/a><p id=\"caption-attachment-27495\" class=\"wp-caption-text\">Step.4 QlikView Table &#8211; QlikView Cross Table<\/p><\/div>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-bar-chart\/\">Read about &#8211; QlikView Bar &amp; Pie Chart<\/a><\/strong><\/p>\n<p>Finally, to view the cross table, create a table box.<\/p>\n<div id=\"attachment_27496\" style=\"width: 239px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/cross5.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-27496\" class=\"wp-image-27496 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/cross5.png\" alt=\"QlikView Table - QlikView Cross Table\" width=\"229\" height=\"279\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/cross5.png 229w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/cross5-123x150.png 123w\" sizes=\"auto, (max-width: 229px) 100vw, 229px\" \/><\/a><p id=\"caption-attachment-27496\" class=\"wp-caption-text\">Step.4 QlikView Cross Table<\/p><\/div>\n<p>In the final table, you can see that the sales values of all the three regions of every salesperson are displayed serially.<\/p>\n<h3>QlikView Straight Table<\/h3>\n<p>QlikView straight table is a basic tabular form of data representation. You can visualize your data in tabular form by creating it through a chart object. We have taken a data file \u2018Product details\u2019 to be viewed as a straight table.<\/p>\n<div id=\"attachment_27497\" style=\"width: 773px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/productrecord-1.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-27497\" class=\"wp-image-27497 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/productrecord-1.png\" alt=\"QlikView Table - QlikView Straight Table\" width=\"763\" height=\"385\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/productrecord-1.png 763w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/productrecord-1-150x76.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/productrecord-1-300x151.png 300w\" sizes=\"auto, (max-width: 763px) 100vw, 763px\" \/><\/a><p id=\"caption-attachment-27497\" class=\"wp-caption-text\">Step.1 QlikView Table &#8211; QlikView Straight Table<\/p><\/div>\n<p><strong>a. How to create a\u00a0straight table in Qlikview with an example?<\/strong><\/p>\n<p>Load a file from the script INSERT option.<\/p>\n<div id=\"attachment_27498\" style=\"width: 744px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/straight1.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-27498\" class=\"wp-image-27498 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/straight1.png\" alt=\"QlikView Table - QlikView Straight Table\" width=\"734\" height=\"513\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/straight1.png 734w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/straight1-150x105.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/straight1-300x210.png 300w\" sizes=\"auto, (max-width: 734px) 100vw, 734px\" \/><\/a><p id=\"caption-attachment-27498\" class=\"wp-caption-text\">Step.2 QlikView Table &#8211; QlikView Straight Table<\/p><\/div>\n<p>Choose Embedded Labels in the Labels column and a preview of your table can be seen.<br \/>\n<strong><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-vs-tableau\/\">Let&#8217;s revise the Difference Between QlikView and Tableau<\/a><\/strong><\/p>\n<div id=\"attachment_27499\" style=\"width: 752px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/straight2.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-27499\" class=\"wp-image-27499 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/straight2.png\" alt=\"QlikView Table - QlikView Straight Table\" width=\"742\" height=\"660\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/straight2.png 742w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/straight2-150x133.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/straight2-300x267.png 300w\" sizes=\"auto, (max-width: 742px) 100vw, 742px\" \/><\/a><p id=\"caption-attachment-27499\" class=\"wp-caption-text\">Step.3 QlikView Table &#8211; QlikView Straight Table<\/p><\/div>\n<p>As soon as you click on FINISH on the file wizard, the data will be loaded in the script.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">LOAD Product_Id,\r\n     Product_Line,\r\n     Product_category,\r\n     Product_quantity,\r\n     Product_cost\r\nFROM\r\n[C:\\Users\\HP\\Desktop\\Dataflair\\productdetails.csv]\r\n(txt, codepage is 1252, embedded labels, delimiter is ',', msq);<\/pre>\n<div id=\"attachment_27500\" style=\"width: 807px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/straight3.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-27500\" class=\"wp-image-27500 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/straight3.png\" alt=\"QlikView Table - QlikView Straight Table\" width=\"797\" height=\"743\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/straight3.png 797w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/straight3-150x140.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/straight3-300x280.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/straight3-768x716.png 768w\" sizes=\"auto, (max-width: 797px) 100vw, 797px\" \/><\/a><p id=\"caption-attachment-27500\" class=\"wp-caption-text\">Step.4 QlikView Table &#8211; QlikView Straight Table<\/p><\/div>\n<p>Save this file CTRL+S with a .qvw extension. Then reload it (CTRL+R). Right-click anywhere on the sheet and select New Sheet Object, then select Chart.<\/p>\n<div id=\"attachment_27501\" style=\"width: 1311px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/straight4.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-27501\" class=\"wp-image-27501 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/straight4.png\" alt=\"QlikView Table - QlikView Straight Table\" width=\"1301\" height=\"919\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/straight4.png 1301w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/straight4-150x106.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/straight4-300x212.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/straight4-768x542.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/straight4-1024x723.png 1024w\" sizes=\"auto, (max-width: 1301px) 100vw, 1301px\" \/><\/a><p id=\"caption-attachment-27501\" class=\"wp-caption-text\">Step.5 QlikView Table &#8211; QlikView Straight Table<\/p><\/div>\n<p>Select Straight Table as the chart type.<\/p>\n<div id=\"attachment_27502\" style=\"width: 874px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/straight5.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-27502\" class=\"wp-image-27502 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/straight5.png\" alt=\"QlikView Table - QlikView Straight Table\" width=\"864\" height=\"714\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/straight5.png 864w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/straight5-150x124.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/straight5-300x248.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/straight5-768x635.png 768w\" sizes=\"auto, (max-width: 864px) 100vw, 864px\" \/><\/a><p id=\"caption-attachment-27502\" class=\"wp-caption-text\">Step.6 QlikView Table &#8211; QlikView Straight Table<\/p><\/div>\n<p>Add the dimensions of the table, style and choose an expression to be added to a measure (field) accordingly.<\/p>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-intervalmatch\/\">Let&#8217;s revise What is QlikView IntervalMatch &amp; Match Function<\/a><\/strong><\/p>\n<div id=\"attachment_27503\" style=\"width: 876px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/straight6.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-27503\" class=\"wp-image-27503 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/straight6.png\" alt=\" QlikView Table - QlikView Straight Table\" width=\"866\" height=\"710\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/straight6.png 866w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/straight6-150x123.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/straight6-300x246.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/straight6-768x630.png 768w\" sizes=\"auto, (max-width: 866px) 100vw, 866px\" \/><\/a><p id=\"caption-attachment-27503\" class=\"wp-caption-text\">Step.7 QlikView Table &#8211; QlikView Straight Table<\/p><\/div>\n<div id=\"attachment_27505\" style=\"width: 877px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/straight7.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-27505\" class=\"wp-image-27505 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/straight7.png\" alt=\"QlikView Table - QlikView Straight Table\" width=\"867\" height=\"715\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/straight7.png 867w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/straight7-150x124.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/straight7-300x247.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/straight7-768x633.png 768w\" sizes=\"auto, (max-width: 867px) 100vw, 867px\" \/><\/a><p id=\"caption-attachment-27505\" class=\"wp-caption-text\">Step.8 QlikView Table &#8211; QlikView Straight Table<\/p><\/div>\n<div id=\"attachment_27504\" style=\"width: 876px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/straight8.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-27504\" class=\"wp-image-27504 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/straight8.png\" alt=\"QlikView Table - QlikView Straight Table\" width=\"866\" height=\"710\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/straight8.png 866w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/straight8-150x123.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/straight8-300x246.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/straight8-768x630.png 768w\" sizes=\"auto, (max-width: 866px) 100vw, 866px\" \/><\/a><p id=\"caption-attachment-27504\" class=\"wp-caption-text\">Step.9 QlikView Table &#8211; QlikView Straight Table<\/p><\/div>\n<p>Click FINISH in order to see the straight table with your data.<\/p>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-star-schema\/\">Do you know about Viewing Table in Star Schema Model<\/a><\/strong><\/p>\n<div id=\"attachment_27507\" style=\"width: 593px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/straight9.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-27507\" class=\"wp-image-27507 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/straight9.png\" alt=\"QlikView Table - QlikView Straight Table\" width=\"583\" height=\"373\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/straight9.png 583w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/straight9-150x96.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/straight9-300x192.png 300w\" sizes=\"auto, (max-width: 583px) 100vw, 583px\" \/><\/a><p id=\"caption-attachment-27507\" class=\"wp-caption-text\">Step.10 QlikView Table &#8211; QlikView Straight Table<\/p><\/div>\n<p>In the table been created, you can see that the sum of the cost of each product line has been done and displayed in the form of a straight table.<\/p>\n<h3>QlikView Pivot Tables<\/h3>\n<p>QlikView pivot table is used to show the sum of values across different dimensions in a table. The pivot table has a unique structure and has collapsible fields. The pivot Table can be created through the chart object.<\/p>\n<p><strong>a. How to create a\u00a0pivot table in Qlikview with an example?<\/strong><\/p>\n<p>To show how to create the pivot table, we will use the same \u2018product details\u2019 file that we have used while making the straight table.<\/p>\n<p>We will start with creating a Chart object. Select Pivot Table as the chart type.<\/p>\n<div id=\"attachment_27508\" style=\"width: 876px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/pivot1.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-27508\" class=\"wp-image-27508 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/pivot1.png\" alt=\" QlikView Table - QlikView Pivot Table\" width=\"866\" height=\"715\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/pivot1.png 866w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/pivot1-150x124.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/pivot1-300x248.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/pivot1-768x634.png 768w\" sizes=\"auto, (max-width: 866px) 100vw, 866px\" \/><\/a><p id=\"caption-attachment-27508\" class=\"wp-caption-text\">Step.1 QlikView Table &#8211; QlikView Pivot Table<\/p><\/div>\n<p>Next step is choosing the dimensions. We have chosen product line and product quantity.<\/p>\n<div id=\"attachment_27512\" style=\"width: 872px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/QlikView-pivot-02.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-27512\" class=\"wp-image-27512 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/QlikView-pivot-02.png\" alt=\"QlikView Table - QlikView Pivot Table\" width=\"862\" height=\"710\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/QlikView-pivot-02.png 862w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/QlikView-pivot-02-150x124.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/QlikView-pivot-02-300x247.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/QlikView-pivot-02-768x633.png 768w\" sizes=\"auto, (max-width: 862px) 100vw, 862px\" \/><\/a><p id=\"caption-attachment-27512\" class=\"wp-caption-text\">Step.2 QlikView Table &#8211; QlikView Pivot Table<\/p><\/div>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-scripting\/\">Let&#8217;s discuss the Features of QlikView Script Editor<\/a><\/strong><\/p>\n<p>Add an expression to a field in the next step. We have applies SUM() function on the cost field. You can also give this expression a label to display.<\/p>\n<div id=\"attachment_27514\" style=\"width: 872px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/QlikView-pivot-03.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-27514\" class=\"wp-image-27514 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/QlikView-pivot-03.png\" alt=\" QlikView Table - QlikView Pivot Table\" width=\"862\" height=\"710\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/QlikView-pivot-03.png 862w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/QlikView-pivot-03-150x124.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/QlikView-pivot-03-300x247.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/QlikView-pivot-03-768x633.png 768w\" sizes=\"auto, (max-width: 862px) 100vw, 862px\" \/><\/a><p id=\"caption-attachment-27514\" class=\"wp-caption-text\">Step.3 QlikView Table &#8211; QlikView Pivot Table<\/p><\/div>\n<p>Select the style of the table.<\/p>\n<div id=\"attachment_27515\" style=\"width: 872px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/QlikView-pivot-03-1.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-27515\" class=\"wp-image-27515 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/QlikView-pivot-03-1.png\" alt=\"QlikView Table - QlikView Pivot Table\" width=\"862\" height=\"710\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/QlikView-pivot-03-1.png 862w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/QlikView-pivot-03-1-150x124.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/QlikView-pivot-03-1-300x247.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/QlikView-pivot-03-1-768x633.png 768w\" sizes=\"auto, (max-width: 862px) 100vw, 862px\" \/><\/a><p id=\"caption-attachment-27515\" class=\"wp-caption-text\">Step.4 QlikView Table &#8211; QlikView Pivot Table<\/p><\/div>\n<p>And then click FINISH. You will have your pivot table ready.<strong>\u00a0<\/strong><\/p>\n<div id=\"attachment_27516\" style=\"width: 439px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/QlikView-pivot-05.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-27516\" class=\"wp-image-27516 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/QlikView-pivot-05.png\" alt=\"QlikView Table - QlikView Pivot Table\" width=\"429\" height=\"263\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/QlikView-pivot-05.png 429w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/QlikView-pivot-05-150x92.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/QlikView-pivot-05-300x184.png 300w\" sizes=\"auto, (max-width: 429px) 100vw, 429px\" \/><\/a><p id=\"caption-attachment-27516\" class=\"wp-caption-text\">Step.5 QlikView Table &#8211; QlikView Pivot Table<\/p><\/div>\n<p>Upon noticing the table, you will realize that each product line has a small plus sing with it. On clicking on that plus sign, opens up a new column in which the individual values of product quantities are given. In the third column, we have the sum of the cost of individual product lines.<\/p>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-database-connection-inline-data\/\">Let&#8217;s study QlikView Database Connection &amp; Inline data<\/a><\/strong><\/p>\n<h3>QlikView Mapping Tables<\/h3>\n<p>In a QlikView mapping table, you can map or mirror a column or field from one table to another. The column that is to be mapped in a table must be related to an another (already existing) column in that table. The map tables are also called<em> Lookup Tables<\/em> as they are used to look up or search for relevant values in columns.<\/p>\n<p><strong>a. How to create a\u00a0mapping table in Qlikview with an example?<\/strong><\/p>\n<p>To create a mapping table, load two tables from a source such that both of them have one column in common.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">LOAD Product_Id,\r\n     Product_Line,\r\n     Product_category,\r\n     Product_quantity,\r\n     Product_cost,\r\n     [Store Location]\r\nFROM\r\n[C:\\Users\\HP\\Desktop\\Dataflair\\productdetails.csv]\r\n(txt, codepage is 1252, embedded labels, delimiter is ',', msq);\r\n\r\nLOAD [Store Location],\r\n     [Store city]\r\nFROM\r\n[C:\\Users\\HP\\Desktop\\Dataflair\\storelocation.csv]\r\n(txt, codepage is 1252, embedded labels, delimiter is ',', msq);<\/pre>\n<div id=\"attachment_27517\" style=\"width: 711px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/map1.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-27517\" class=\"wp-image-27517 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/map1.png\" alt=\"QlikView Mapping Table\" width=\"701\" height=\"415\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/map1.png 701w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/map1-150x89.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/map1-300x178.png 300w\" sizes=\"auto, (max-width: 701px) 100vw, 701px\" \/><\/a><p id=\"caption-attachment-27517\" class=\"wp-caption-text\">Step.1 QlikView Mapping Table<\/p><\/div>\n<p>Now if we create the table boxes out of this loaded data, we can only create two separate tables with store location and city in a separate one.<\/p>\n<div id=\"attachment_27518\" style=\"width: 1173px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/map2.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-27518\" class=\"wp-image-27518 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/map2.png\" alt=\"QlikView Table - QlikView Mapping Table\" width=\"1163\" height=\"508\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/map2.png 1163w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/map2-150x66.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/map2-300x131.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/map2-768x335.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/map2-1024x447.png 1024w\" sizes=\"auto, (max-width: 1163px) 100vw, 1163px\" \/><\/a><p id=\"caption-attachment-27518\" class=\"wp-caption-text\">Step.2 QlikView Mapping Table<\/p><\/div>\n<p>In order to map the \u2018City\u2019 column in the main table, some changes in the script code have to do and the Mapping function apply.<\/p>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-careers\/\">Have a look &#8211; QlikView Careers Opportunity<\/a><\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">mapStoredetails:\r\nMapping LOAD [Store Location],\r\n               City\r\nFROM\r\n[C:\\Users\\HP\\Desktop\\Dataflair\\store .csv]\r\n(txt, codepage is 1252, embedded labels, delimiter is ',', msq);\r\n\r\nProductdetails:\r\nLOAD Product_Id,\r\n     Product_Line,\r\n     Product_category,\r\n     Product_quantity,\r\n     Product_cost,\r\n     [Store Location],\r\n     ApplyMap('mapStoredetails', [Store Location],'Unknown') as City\r\nFROM\r\n[C:\\Users\\HP\\Desktop\\Dataflair\\productdetails.csv]\r\n(txt, codepage is 1252, embedded labels, delimiter is ',', msq);<\/pre>\n<div id=\"attachment_27519\" style=\"width: 1930px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/map3.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-27519\" class=\"wp-image-27519 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/map3.png\" alt=\" QlikView Mapping Table\" width=\"1920\" height=\"1030\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/map3.png 1920w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/map3-150x80.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/map3-300x161.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/map3-768x412.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/map3-1024x549.png 1024w\" sizes=\"auto, (max-width: 1920px) 100vw, 1920px\" \/><\/a><p id=\"caption-attachment-27519\" class=\"wp-caption-text\">Step.3 QlikView Mapping Table<\/p><\/div>\n<p>Save and reload this new script and create a table box to view the mapping.<\/p>\n<div id=\"attachment_27521\" style=\"width: 885px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/map4.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-27521\" class=\"wp-image-27521 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/map4.png\" alt=\"QlikView Table - QlikView Mapping Table\" width=\"875\" height=\"401\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/map4.png 875w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/map4-150x69.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/map4-300x137.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/map4-768x352.png 768w\" sizes=\"auto, (max-width: 875px) 100vw, 875px\" \/><\/a><p id=\"caption-attachment-27521\" class=\"wp-caption-text\">Step.4 QlikView Mapping Table<\/p><\/div>\n<p>The table now has the column \u2018City\u2019 mapped onto the Product Details table.<\/p>\n<p>So, this was all about QlikView Table Tutorial. Hope you like our explanation.<\/p>\n<h3>Conclusion<\/h3>\n<p>Hence, in this QlikView Table tutorial, we learned about four different kinds of tables namely Cross, Straight, Pivot and Mapping. What purpose they serve is quite evident by their names. We hope you had a hassle-free experience in understanding and creating these tables with us. In case of any queries or suggestions, do leave your comment below.<\/p>\n<p>Related Topic &#8211;\u00a0<strong><a href=\"https:\/\/data-flair.training\/blogs\/qvd-files\/\">What are the QVD Files?<\/a><\/strong><\/p>\n<p><strong><a href=\"https:\/\/help.qlik.com\/en-US\/qlikview\/November2017\/...\/Client\/...\/Straight_Table.htm\">For reference<\/a><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In our last session, we discussed QlikView Autogenerate. Now, in this QlikView Table Tutorial, we are going to learn how to create: QlikView\u00a0Cross Table, QlikView Straight Table, QlikView Pivot Table, and\u00a0QlikView Mapping Table with&#46;&#46;&#46;<\/p>\n","protected":false},"author":6,"featured_media":27522,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[47],"tags":[6088,6172,11029,11049,11068,11071,15885],"class_list":["post-27467","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-qlikview","tag-how-to-create-pivot-table-in-qlikview","tag-how-to-draw-qlikview-tables","tag-qlikview-mapping-table","tag-qlikview-pivot-table","tag-qlikview-straight-table","tag-qlikview-table-tutorial","tag-what-is-qlikview-table"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>QlikView Table - Creating Cross, Straight, Pivot, Mapping Tables - DataFlair<\/title>\n<meta name=\"description\" content=\"QlikView Table Tutorial - How to Create QlikView Cross Table, Steps to make QlikView Straight Table, Creating QlikView Pivot Table, QlikView Mapping Table\" \/>\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-table\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"QlikView Table - Creating Cross, Straight, Pivot, Mapping Tables - DataFlair\" \/>\n<meta property=\"og:description\" content=\"QlikView Table Tutorial - How to Create QlikView Cross Table, Steps to make QlikView Straight Table, Creating QlikView Pivot Table, QlikView Mapping Table\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/qlikview-table\/\" \/>\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-09-07T03:30:22+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-12-07T05:54:50+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/QlikView-Tables-01-1.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=\"12 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"QlikView Table - Creating Cross, Straight, Pivot, Mapping Tables - DataFlair","description":"QlikView Table Tutorial - How to Create QlikView Cross Table, Steps to make QlikView Straight Table, Creating QlikView Pivot Table, QlikView Mapping Table","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-table\/","og_locale":"en_US","og_type":"article","og_title":"QlikView Table - Creating Cross, Straight, Pivot, Mapping Tables - DataFlair","og_description":"QlikView Table Tutorial - How to Create QlikView Cross Table, Steps to make QlikView Straight Table, Creating QlikView Pivot Table, QlikView Mapping Table","og_url":"https:\/\/data-flair.training\/blogs\/qlikview-table\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-09-07T03:30:22+00:00","article_modified_time":"2021-12-07T05:54:50+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/QlikView-Tables-01-1.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":"12 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/qlikview-table\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-table\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89"},"headline":"QlikView Table &#8211; Creating Cross, Straight, Pivot, Mapping Tables","datePublished":"2018-09-07T03:30:22+00:00","dateModified":"2021-12-07T05:54:50+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-table\/"},"wordCount":1440,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-table\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/QlikView-Tables-01-1.jpg","keywords":["How to create Pivot Table in QlikView","How to draw QlikView Tables","QlikView Mapping Table","QlikView Pivot Table","QlikView Straight Table","QlikView Table Tutorial","What is QlikView Table"],"articleSection":["QlikView Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/qlikview-table\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/qlikview-table\/","url":"https:\/\/data-flair.training\/blogs\/qlikview-table\/","name":"QlikView Table - Creating Cross, Straight, Pivot, Mapping Tables - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-table\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-table\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/QlikView-Tables-01-1.jpg","datePublished":"2018-09-07T03:30:22+00:00","dateModified":"2021-12-07T05:54:50+00:00","description":"QlikView Table Tutorial - How to Create QlikView Cross Table, Steps to make QlikView Straight Table, Creating QlikView Pivot Table, QlikView Mapping Table","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-table\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/qlikview-table\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/qlikview-table\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/QlikView-Tables-01-1.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/QlikView-Tables-01-1.jpg","width":1200,"height":628,"caption":"QlikView Table"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/qlikview-table\/#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 Table &#8211; Creating Cross, Straight, Pivot, Mapping Tables"}]},{"@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\/27467","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=27467"}],"version-history":[{"count":8,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/27467\/revisions"}],"predecessor-version":[{"id":105191,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/27467\/revisions\/105191"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/27522"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=27467"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=27467"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=27467"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}