{"id":46271,"date":"2018-12-26T10:14:43","date_gmt":"2018-12-26T04:44:43","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=46271"},"modified":"2018-12-26T12:21:49","modified_gmt":"2018-12-26T06:51:49","slug":"qlik-sense-pivot-table","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/qlik-sense-pivot-table\/","title":{"rendered":"Qlik Sense Pivot Table – Learn Pivoting in Qlik Sense"},"content":{"rendered":"

Earlier, we discussed Maps in Qlik Sense<\/a>.\u00a0<\/strong>Today, we will see the Qlik Sense Pivot Table. In this tutorial, we will learn about a special kind of table known as the pivot table. Also, we will see how different is the pivot table from the normal table and how to use it.\u00a0<\/span><\/p>\n

So, let’s start Qlik Sense Pivot Table.<\/p>\n

\"Qlik<\/a>

Qlik Sense Pivot Table – Learn Pivoting in Qlik Sense<\/p><\/div>\n

1. What is Qlik Sense Pivot Table?<\/h2>\n

A pivot table consists of rows and columns which contains dimensions and measure fields. We can switch the position of dimensions and measures between columns and rows in a pivot table. We call it pivoting. By pivoting the view of table changes and the field values are shown accordingly. In a pivot table, you can view multiple dimensions and measures interchangeably in different views.<\/span><\/p>\n

Recommended Reading –<\/strong> Tables in Qlik Sense<\/a><\/strong><\/p>\n

\"Qlik<\/a>

View Multiple Dimensions and Measures<\/p><\/div>\n

Shown above is a pivot table having three dimensions on the left in the row section and two measures <\/span>Quantity<\/span><\/i> and <\/span>Sales<\/span><\/i> on the right section which collectively displays all the measure fields as columns. You move dimensions or measures from column to rows or rows to columns section by dragging them. <\/span><\/p>\n

For instance, if we move the dimension <\/span>Customer<\/span><\/i> to the columns section on the right, the table will be updated to show <\/span>Quantity<\/span><\/i> and <\/span>Sales<\/span><\/i> for each customer. <\/span><\/p>\n

\"Qlik<\/a>

Quantity and sales for each customer<\/p><\/div>\n

2. How to Create a Qlik Sense Pivot Table?<\/h2>\n

In order to create a Qlik Sense Pivot Table, follow the steps below. <\/span><\/p>\n

Step 1<\/b>: Open the editor of the sheet of the application in which you want to create a pivot table. The editor is opened from the <\/span>Edit<\/b> option present on the toolbar of the sheet.<\/span><\/p>\n

Step 2<\/b>: Select the option <\/span>Pivot table<\/b> (from the Assets Panel) and add it to the editing grid at the center by dragging and dropping. <\/span><\/p>\n

\"Qlik<\/a>

Select Pivot Table from Asserts Panel<\/p><\/div>\n

Step 3<\/b>: Add a measure and dimension to start with creating the table. You add more columns in the table from the properties panel at the right of the editor. <\/span><\/p>\n

Step 4<\/b>: Once you are done with selecting and adjusting all the aspects of the table from the properties panel, the table will be displayed on the editor instantly. Click <\/span>Done<\/b> to bring it on the sheet. <\/span><\/p>\n

\"Qlik<\/a>

Displaying the Table<\/p><\/div>\n

3. Properties Panel in Qlik Sense Pivot Table<\/span><\/h2>\n

From the properties panel present at the right of the editor, you can manage different aspects of the pivot table and modify it according to your requirement.<\/span><\/p>\n

Have a look at Qlik Sense\u00a0Line Charts<\/a><\/strong><\/p>\n

i. Data<\/span><\/h3>\n

From the data tab, you can add dimensions and measures as row and column for the table. You can do the pivoting of dimensions and measures from here also by dragging the field names up and down. \u00a0<\/span><\/p>\n

\"Qlik<\/a>

Add Dimensions and Measures<\/p><\/div>\n

You can edit each column individually by clicking on the arrow given beside the name of the column. The options include expression, label, number formatting (if it is a measure), etc. <\/span><\/p>\n

ii. Sorting<\/span><\/h3>\n

From the sorting tab you can sort the dimensions and measures in different ways, like sort by the expression, sort by load order, sort numerically, sort alphabetically etc. <\/span><\/p>\n

\"Qlik<\/a>

Sorting in Qlik Sense Pivot Table<\/p><\/div>\n

iii. Add-ons<\/span><\/h3>\n

In this section, you can use the data handling option to apply certain display conditions on the data used in the pivot table. The \u2018Include zero values\u2019 option includes all the 0s that are present in a measure field as value and displays them. \u00a0<\/span><\/p>\n

\"Qlik<\/a>

Add-ons section in Qlik Sense<\/p><\/div>\n

iv. Appearance<\/span><\/h3>\n

The appearance section contains all the setting related to the appearance of the pivot table. \u00a0<\/span><\/p>\n

The first section is the <\/span>General<\/span><\/i> section has options for showing or hiding titles or details. The <\/span>Presentation<\/span><\/i> section gives you options to fully expand the table without any collapsed rows and to indent rows. <\/span><\/p>\n

\"Qlik<\/a>

Presentation Section in Qlik Sense Pivot Table<\/p><\/div>\n

If you do not select the <\/span>Fully expanded<\/span><\/i> option, then the table will look as shown in the image below. <\/span><\/p>\n

\"Qlik<\/a>

Fully expanded option is not selected<\/p><\/div>\n

But, if you select the Fully expanded option, then the table is expanded to show all the details and values. <\/span><\/p>\n

\"Qlik<\/a>

Fully expanded option is selected<\/p><\/div>\n

Do you know about Qlik Sense Scatter Plot Visualization?<\/a><\/strong><\/p>\n

4. Pivoting in Qlik Sense<\/span><\/h2>\n

In a Qlik Sense<\/a><\/strong> Pivot Table, pivoting can be done in two ways, i.e. either from the properties panel or from the pivot table present on the sheet. Refer to the table that we created in the \u2018Creating a pivot table\u2019 section. We can apply pivoting by moving the dimension \u2018<\/span>Product_line\u2019<\/span><\/i> to the measures\/columns section. The updated pivot table is shown in the image below. As you can see, it shows average cost and total units for each product_line like Apparel & Accessories, Arts & Entertainments, Hardware etc. In each of these columns, the values are shown corresponding to the product category values and other cells are left blank with a dash in them. <\/span><\/p>\n

\"Qlik<\/a>

Pivoting in Qlik Sense<\/p><\/div>\n

You can also apply limitations or conditions on the data set and do global grouping which reflects on all the dimension and measure values. This is done from the data section of the properties panel.<\/span><\/p>\n

\"Qlik<\/a>

Apply limitations and conditions on the data set<\/p><\/div>\n

For instance, in the table shown below, which has names of sales representative and year. On the other hand, the column section is the sum(Sales) measure. <\/span><\/p>\n

\"Qlik<\/a>

Qlik Sense Pivoting<\/p><\/div>\n

We will apply limitations on this table such that only those sales representative\u2019s names will be shown which have the top 5 total sales. This limitation or condition will be applied to all the year through global grouping. <\/span><\/p>\n

\"Qlik<\/a>

Applying limitations on the table<\/p><\/div>\n

Thus, the new pivot table will only show the top 5 sales representative for each year. <\/span><\/p>\n

5. Advantages and Limitations<\/span><\/h2>\n

The biggest advantage of using a pivot table is that you can view data in different forms with different perspectives. You can shuffle between rows and columns and dimensions and measures to gain new views of the table. You can use multiple dimensions and measures in pivoting. Although, for some users what comes out as a limitation is that pivot tables might seem complicated to deal with sometimes and requires some skills.<\/span><\/p>\n

Let’s revise Qlik Sense Logical Functions<\/a><\/strong><\/p>\n

So, this was all in Qlik Sense Pivot Table.<\/p>\n

6. Conclusion<\/span><\/h2>\n

Thus, this was all that we needed to learn in Qlik Sense Pivot Table. We hope this information helped you in creating a pivot table using your data. Still, if you feel any query related to Qlik Sense Pivot table ask in the comment section.\u00a0<\/span><\/p>\n

You must check –<\/strong> Qlik Sense Financial Functions<\/a><\/strong>

Earlier, we discussed Maps in Qlik Sense.\u00a0Today, we will see the Qlik Sense Pivot Table. In this tutorial, we will learn about a special kind of table known as the pivot table. Also, we...<\/p>\n","protected":false},"author":6,"featured_media":46304,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17408],"tags":[18090,18089,18058,18088],"class_list":["post-46271","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-qlik-sense-tutorials","tag-create-a-qlik-sense-pivot-table","tag-pivot-table-in-qlik-sense","tag-properties-panel-in-qlik-sense","tag-qlik-sense-pivot-table"],"yoast_head":"\nQlik Sense Pivot Table - Learn Pivoting in Qlik Sense - DataFlair<\/title>\n<meta name=\"description\" content=\"What is Qlik Sense Pivot table,how to create pivot tables in Qlik Sense, properties panel, advantages and disadvantages in pivot, pioting in qlik sense\" \/>\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\/qlik-sense-pivot-table\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Qlik Sense Pivot Table - Learn Pivoting in Qlik Sense - DataFlair\" \/>\n<meta property=\"og:description\" content=\"What is Qlik Sense Pivot table,how to create pivot tables in Qlik Sense, properties panel, advantages and disadvantages in pivot, pioting in qlik sense\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/qlik-sense-pivot-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-12-26T04:44:43+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-12-26T06:51:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/Qlik-Sense-Pivot-Table-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=\"6 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Qlik Sense Pivot Table - Learn Pivoting in Qlik Sense - DataFlair","description":"What is Qlik Sense Pivot table,how to create pivot tables in Qlik Sense, properties panel, advantages and disadvantages in pivot, pioting in qlik sense","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\/qlik-sense-pivot-table\/","og_locale":"en_US","og_type":"article","og_title":"Qlik Sense Pivot Table - Learn Pivoting in Qlik Sense - DataFlair","og_description":"What is Qlik Sense Pivot table,how to create pivot tables in Qlik Sense, properties panel, advantages and disadvantages in pivot, pioting in qlik sense","og_url":"https:\/\/data-flair.training\/blogs\/qlik-sense-pivot-table\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-12-26T04:44:43+00:00","article_modified_time":"2018-12-26T06:51:49+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/Qlik-Sense-Pivot-Table-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":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-pivot-table\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-pivot-table\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89"},"headline":"Qlik Sense Pivot Table – Learn Pivoting in Qlik Sense","datePublished":"2018-12-26T04:44:43+00:00","dateModified":"2018-12-26T06:51:49+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-pivot-table\/"},"wordCount":1230,"commentCount":4,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-pivot-table\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/Qlik-Sense-Pivot-Table-01.jpg","keywords":["Create a Qlik Sense Pivot Table","Pivot Table in Qlik Sense","Properties panel in Qlik Sense","Qlik Sense Pivot Table"],"articleSection":["Qlik Sense Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/qlik-sense-pivot-table\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-pivot-table\/","url":"https:\/\/data-flair.training\/blogs\/qlik-sense-pivot-table\/","name":"Qlik Sense Pivot Table - Learn Pivoting in Qlik Sense - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-pivot-table\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-pivot-table\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/Qlik-Sense-Pivot-Table-01.jpg","datePublished":"2018-12-26T04:44:43+00:00","dateModified":"2018-12-26T06:51:49+00:00","description":"What is Qlik Sense Pivot table,how to create pivot tables in Qlik Sense, properties panel, advantages and disadvantages in pivot, pioting in qlik sense","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-pivot-table\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/qlik-sense-pivot-table\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-pivot-table\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/Qlik-Sense-Pivot-Table-01.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/Qlik-Sense-Pivot-Table-01.jpg","width":1200,"height":628,"caption":"Qlik Sense Pivot Table - Learn Pivoting in Qlik Sense"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-pivot-table\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"Qlik Sense Tutorials","item":"https:\/\/data-flair.training\/blogs\/category\/qlik-sense-tutorials\/"},{"@type":"ListItem","position":3,"name":"Qlik Sense Pivot Table – Learn Pivoting in Qlik Sense"}]},{"@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\/46271","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=46271"}],"version-history":[{"count":4,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/46271\/revisions"}],"predecessor-version":[{"id":46371,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/46271\/revisions\/46371"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/46304"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=46271"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=46271"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=46271"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}