{"id":46173,"date":"2018-12-23T11:43:11","date_gmt":"2018-12-23T06:13:11","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=46173"},"modified":"2018-12-22T14:43:24","modified_gmt":"2018-12-22T09:13:24","slug":"qlik-sense-tables","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/qlik-sense-tables\/","title":{"rendered":"Qlik Sense Tables &#8211; Exploring the Tables in Qlik Sense"},"content":{"rendered":"<div class='__iawmlf-post-loop-links' style='display:none;' data-iawmlf-post-links='[{&quot;id&quot;:1641,&quot;href&quot;:&quot;https:\\\/\\\/www.qlik.com\\\/us\\\/products\\\/qlik-sense&quot;,&quot;archived_href&quot;:&quot;http:\\\/\\\/web-wp.archive.org\\\/web\\\/20250910054814\\\/https:\\\/\\\/www.qlik.com\\\/us\\\/products\\\/qlik-sense&quot;,&quot;redirect_href&quot;:&quot;&quot;,&quot;checks&quot;:[{&quot;date&quot;:&quot;2025-12-09 14:59:04&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-12 19:36:36&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-16 00:14:49&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-19 05:16:53&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-22 07:28:18&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-25 14:15:00&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-29 02:13:23&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-01 05:49:02&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-04 07:22:12&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-07 08:15:48&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-11 13:51:12&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-14 16:21:34&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-19 02:44:56&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-22 03:03:05&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-25 11:06:55&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-28 12:37:56&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-01 00:15:05&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-04 05:47:54&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-07 12:47:20&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-10 15:45:46&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-13 17:01:17&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-16 17:50:31&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-20 06:42:11&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-23 09:55:01&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-26 10:25:41&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-01 16:39:38&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-05 05:06:15&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-08 11:22:30&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-11 13:38:36&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-14 19:24:16&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-18 01:36:05&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-21 23:13:54&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-25 01:59:39&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-29 13:02:13&quot;,&quot;http_code&quot;:503},{&quot;date&quot;:&quot;2026-04-01 13:05:32&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-04 14:23:51&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-07 17:56:15&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-10 21:58:08&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-14 04:26:17&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-17 06:08:44&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-20 07:37:20&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-23 09:28:49&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-27 07:37:07&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-30 08:39:05&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-04 07:49:58&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-07 09:05:20&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-10 12:55:16&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-13 15:31:27&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-17 20:04:48&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-21 03:24:04&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-25 05:12:13&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-28 09:09:10&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-06-01 06:19:49&quot;,&quot;http_code&quot;:206}],&quot;broken&quot;:false,&quot;last_checked&quot;:{&quot;date&quot;:&quot;2026-06-01 06:19:49&quot;,&quot;http_code&quot;:206},&quot;process&quot;:&quot;done&quot;}]'><\/div>\n<p><span style=\"font-weight: 400\">Earlier, we discussed <strong><a href=\"https:\/\/data-flair.training\/blogs\/kpi-in-qlik-sense\/\">Qlik Sense KPI<\/a><\/strong>. In this tutorial, we will explore the most important element of visualizations i.e. the Qlik Sense Tables. However, in the internal logic of Qlik Sense, data is stored and structured in the form of tables but at the user\u2019s end, you have the freedom to select how you would like the data to be displayed, i.e. as a <strong><a href=\"https:\/\/data-flair.training\/blogs\/qlik-sense-gauge-chart\/\">chart<\/a><\/strong>, KPI, map etc. But here, our focus will just be on using tables as the visualization.<\/span><\/p>\n<p>So, let&#8217;s start Qlik Sense Tables Tutorial.<\/p>\n<div id=\"attachment_46195\" style=\"width: 1210px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/Qlik-Sense-Tables-01.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-46195\" class=\"size-full wp-image-46195\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/Qlik-Sense-Tables-01.jpg\" alt=\"Qlik Sense Tables - Exploring the Tables in Qlik Sense\" width=\"1200\" height=\"628\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/Qlik-Sense-Tables-01.jpg 1200w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/Qlik-Sense-Tables-01-150x79.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/Qlik-Sense-Tables-01-300x157.jpg 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/Qlik-Sense-Tables-01-768x402.jpg 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/Qlik-Sense-Tables-01-1024x536.jpg 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/Qlik-Sense-Tables-01-520x272.jpg 520w\" sizes=\"auto, (max-width: 1200px) 100vw, 1200px\" \/><\/a><p id=\"caption-attachment-46195\" class=\"wp-caption-text\">Qlik Sense Tables &#8211; Exploring the Tables in Qlik Sense<\/p><\/div>\n<h2>1. What are Qlik Sense Tables?<\/h2>\n<p><span style=\"font-weight: 400\">Displaying data in tables is simple yet a detailed way of data representation in Qlik Sense. Usually, while using other kinds of<strong><a href=\"https:\/\/data-flair.training\/blogs\/selections-in-qlik-sense\/\"> visualizations<\/a><\/strong> like charts and maps, we analyze them by looking at the trends and patterns they reveal the data. But a table simply shows the data in detail arranged in columns and rows. Data values in a table is always logically associated with the corresponding values spread across rows and columns. The columns can be both dimensions and measures. Also, drilling down in group dimensions in case of large data sets is very convenient to do. Qlik Sense provides many options to display the data values in different ways like setting background color condition, text color condition, visibility condition etc. <\/span><\/p>\n<div id=\"attachment_46177\" style=\"width: 930px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/table1.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-46177\" class=\"size-full wp-image-46177\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/table1.png\" alt=\"Qlik Sense Tables\" width=\"920\" height=\"543\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/table1.png 920w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/table1-150x89.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/table1-300x177.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/table1-768x453.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/table1-520x307.png 520w\" sizes=\"auto, (max-width: 920px) 100vw, 920px\" \/><\/a><p id=\"caption-attachment-46177\" class=\"wp-caption-text\">What are Qlik Sense Tables<\/p><\/div>\n<h2>2. How to create a Table in Qlik Sense?<\/h2>\n<p><span style=\"font-weight: 400\">In order to create a table in Qlik Sense, follow the steps given below. <\/span><\/p>\n<p><b>Step 1<\/b><span style=\"font-weight: 400\">: Open the editor of the sheet of the application in which you want to create a table. The editor is opened from the <\/span><b>Edit<\/b><span style=\"font-weight: 400\"> option present on the toolbar of the sheet.<\/span><\/p>\n<p><b>Step 2<\/b><span style=\"font-weight: 400\">: Select the option <\/span><b>Table<\/b><span style=\"font-weight: 400\"> (from the Assets Panel) and add it to the editing grid at the center by dragging and dropping. <\/span><\/p>\n<div id=\"attachment_46178\" style=\"width: 1925px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/table2.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-46178\" class=\"size-full wp-image-46178\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/table2.png\" alt=\"Qlik Sense Tables\" width=\"1915\" height=\"1003\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/table2.png 1915w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/table2-150x79.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/table2-300x157.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/table2-768x402.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/table2-1024x536.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/table2-520x272.png 520w\" sizes=\"auto, (max-width: 1915px) 100vw, 1915px\" \/><\/a><p id=\"caption-attachment-46178\" class=\"wp-caption-text\">Select Table from Assert Panel<\/p><\/div>\n<p><b>Step 3<\/b><span style=\"font-weight: 400\">: 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<p><b>Step 4<\/b><span style=\"font-weight: 400\">: Once you are done with selecting and adjusting all the aspects of the table, the table will be displayed on the editor instantly. Click <\/span><b>Done<\/b><span style=\"font-weight: 400\"> to bring it on the sheet.<\/span><\/p>\n<p><strong>Recommended Reading &#8211;<\/strong> <strong><a href=\"https:\/\/data-flair.training\/blogs\/qlik-sense-table-functions\/\">Qlik Sense Table Functions<\/a><\/strong><\/p>\n<div id=\"attachment_46179\" style=\"width: 923px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/table3.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-46179\" class=\"size-full wp-image-46179\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/table3.png\" alt=\"Qlik Sense Tables\" width=\"913\" height=\"543\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/table3.png 913w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/table3-150x89.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/table3-300x178.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/table3-768x457.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/table3-520x309.png 520w\" sizes=\"auto, (max-width: 913px) 100vw, 913px\" \/><\/a><p id=\"caption-attachment-46179\" class=\"wp-caption-text\">Displaying the Table<\/p><\/div>\n<p><span style=\"font-weight: 400\">We will discuss how to add a column, align the text, format the values, color values, and cells, in the section <\/span><i><span style=\"font-weight: 400\">properties panel<\/span><\/i><span style=\"font-weight: 400\"> given below. \u00a0<\/span><\/p>\n<h2><span style=\"font-weight: 400\">3. Exploring Qlik Sense Tables<\/span><\/h2>\n<p><span style=\"font-weight: 400\">In Qlik Sense tables, you can align the text for each column. By default, the text alignment is left for the text values and right for the numeric values. You can change the alignment by changing the setting to <\/span><i><span style=\"font-weight: 400\">Custom<\/span><\/i><span style=\"font-weight: 400\"> option. You can also make selections in tables and search for values through the search lens present in the dimension columns. Search gives quick results. <\/span><\/p>\n<p><span style=\"font-weight: 400\">You can sort a table in four different ways, i.e. row sorting, column sorting, internal sorting, and interactive sorting. <\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><i><span style=\"font-weight: 400\">Column sorting<\/span><\/i><span style=\"font-weight: 400\"> is done usually as per the load order i.e. which column was added first will be the first in the sort order as well. You can change it from the properties panel if you wish. <\/span><\/li>\n<li style=\"font-weight: 400\"><i><span style=\"font-weight: 400\">Row sorting<\/span><\/i><span style=\"font-weight: 400\"> is the row values based on which other column values are sorted. The column based on whose values sorting is done is indicated by an arrow below the name of that column. <\/span><\/li>\n<li style=\"font-weight: 400\"><i><span style=\"font-weight: 400\">Internal sorting<\/span><\/i><span style=\"font-weight: 400\"> is the way the values of each column are sorted internally. <\/span><\/li>\n<li style=\"font-weight: 400\"><i><span style=\"font-weight: 400\">Interactive sorting<\/span><\/i><span style=\"font-weight: 400\"> is the way of sorting values by clicking on the column header. Values are sorted in a certain way upon making the first click and resumes the original state on the second click. <\/span><\/li>\n<\/ul>\n<h2><span style=\"font-weight: 400\">4. Qlik Sense Tables Properties Panel<\/span><\/h2>\n<p><span style=\"font-weight: 400\">From the properties panel present at the right of the editor, you can manage different aspects of the table and modify it according to your requirement.<\/span><\/p>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlik-sense-integer-functions\/\">Have a look at Qlik Sense Integer Functions<\/a><\/strong><\/p>\n<h3><span style=\"font-weight: 400\">i. Data<\/span><\/h3>\n<p><span style=\"font-weight: 400\">From the data tab, you can add columns for the table. While adding new columns you get to choose whether you want to add a dimension or a measure. <\/span><\/p>\n<div id=\"attachment_46180\" style=\"width: 325px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/table4a.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-46180\" class=\"size-full wp-image-46180\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/table4a.png\" alt=\"Qlik Sense Tables\" width=\"315\" height=\"575\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/table4a.png 315w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/table4a-82x150.png 82w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/table4a-164x300.png 164w\" sizes=\"auto, (max-width: 315px) 100vw, 315px\" \/><\/a><p id=\"caption-attachment-46180\" class=\"wp-caption-text\">Data Option in Qlik Sense Tables<\/p><\/div>\n<p><span style=\"font-weight: 400\">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), column condition, background color expression, text color expression, total function (if you want to add the totals column), text alignment etc. <\/span><\/p>\n<div id=\"attachment_46181\" style=\"width: 325px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/table4b.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-46181\" class=\"size-full wp-image-46181\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/table4b.png\" alt=\"Qlik Sense Tables\" width=\"315\" height=\"865\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/table4b.png 315w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/table4b-55x150.png 55w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/table4b-109x300.png 109w\" sizes=\"auto, (max-width: 315px) 100vw, 315px\" \/><\/a><p id=\"caption-attachment-46181\" class=\"wp-caption-text\">Edit Column in Qlik Sense<\/p><\/div>\n<div id=\"attachment_46182\" style=\"width: 311px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/table4c.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-46182\" class=\"size-full wp-image-46182\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/table4c.png\" alt=\"Qlik Sense Tables\" width=\"301\" height=\"629\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/table4c.png 301w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/table4c-72x150.png 72w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/table4c-144x300.png 144w\" sizes=\"auto, (max-width: 301px) 100vw, 301px\" \/><\/a><p id=\"caption-attachment-46182\" class=\"wp-caption-text\">Add the Total column<\/p><\/div>\n<p><span style=\"font-weight: 400\">As you can see in the table that we created earlier, we have put a text color condition on the column labeled <\/span><i><span style=\"font-weight: 400\">Total quantity<\/span><\/i><span style=\"font-weight: 400\">.<\/span> <span style=\"font-weight: 400\">The condition is to show the values below 25 in red and all the others in green. Similar conditions have been put on the columns <\/span><i><span style=\"font-weight: 400\">Country<\/span><\/i><span style=\"font-weight: 400\"> and <\/span><i><span style=\"font-weight: 400\">Total sales<\/span><\/i><span style=\"font-weight: 400\"> (values below 1,50,000 in red).<\/span><\/p>\n<p><strong>You must read &#8211;<\/strong> <strong><a href=\"https:\/\/data-flair.training\/blogs\/qlik-sense-system-functions\/\">Qlik Sense System Functions<\/a><\/strong><\/p>\n<h3><span style=\"font-weight: 400\">ii. Sorting<\/span><\/h3>\n<p><span style=\"font-weight: 400\">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<div id=\"attachment_46183\" style=\"width: 321px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/table5.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-46183\" class=\"size-full wp-image-46183\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/table5.png\" alt=\"Qlik Sense Tables\" width=\"311\" height=\"747\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/table5.png 311w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/table5-62x150.png 62w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/table5-125x300.png 125w\" sizes=\"auto, (max-width: 311px) 100vw, 311px\" \/><\/a><p id=\"caption-attachment-46183\" class=\"wp-caption-text\">Sorting in Qlik Sense Tables<\/p><\/div>\n<h3><span style=\"font-weight: 400\">iii. Add-ons<\/span><\/h3>\n<p><span style=\"font-weight: 400\">In this section, you can use the data handling option to apply certain display conditions on the data used in the 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<div id=\"attachment_46184\" style=\"width: 323px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/table6.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-46184\" class=\"size-full wp-image-46184\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/table6.png\" alt=\"Qlik Sense Tables\" width=\"313\" height=\"451\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/table6.png 313w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/table6-104x150.png 104w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/table6-208x300.png 208w\" sizes=\"auto, (max-width: 313px) 100vw, 313px\" \/><\/a><p id=\"caption-attachment-46184\" class=\"wp-caption-text\">Add-ons in Qlik Sense<\/p><\/div>\n<h3><span style=\"font-weight: 400\">iv. Appearance<\/span><\/h3>\n<p><span style=\"font-weight: 400\">The appearance section contains all the setting related to the appearance of the table. \u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">The first section is the <\/span><i><span style=\"font-weight: 400\">General<\/span><\/i><span style=\"font-weight: 400\"> section has options for showing or hiding titles or details.<\/span><\/p>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlik-sense-bookmarking-selections\/\">Have a look at Qlik Sense Bookmarking Selections<\/a><\/strong><\/p>\n<div id=\"attachment_46185\" style=\"width: 327px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/table7a.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-46185\" class=\"size-full wp-image-46185\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/table7a.png\" alt=\"Qlik Sense Tables\" width=\"317\" height=\"649\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/table7a.png 317w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/table7a-73x150.png 73w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/table7a-147x300.png 147w\" sizes=\"auto, (max-width: 317px) 100vw, 317px\" \/><\/a><p id=\"caption-attachment-46185\" class=\"wp-caption-text\">Appearance in Qlik Sense<\/p><\/div>\n<p><span style=\"font-weight: 400\">The <\/span><i><span style=\"font-weight: 400\">Presentation<\/span><\/i><span style=\"font-weight: 400\"> section gives you options to add the totals row at the top of the table. You can also change the position of the totals, edit the label, do text wrapping etc.<\/span><\/p>\n<div id=\"attachment_46186\" style=\"width: 325px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/table7b.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-46186\" class=\"size-full wp-image-46186\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/table7b.png\" alt=\"Qlik Sense Tables\" width=\"315\" height=\"773\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/table7b.png 315w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/table7b-61x150.png 61w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/table7b-122x300.png 122w\" sizes=\"auto, (max-width: 315px) 100vw, 315px\" \/><\/a><p id=\"caption-attachment-46186\" class=\"wp-caption-text\">Change the Position in Appearance<\/p><\/div>\n<p>So, this was all in Qlik Sense Tables.<\/p>\n<h2><span style=\"font-weight: 400\">5. Summary<\/span><\/h2>\n<p><span style=\"font-weight: 400\">We hope this tutorial helped you in understanding tables in <strong><a href=\"https:\/\/www.qlik.com\/us\/products\/qlik-sense\">Qlik Sense<\/a> <\/strong>better. So, now you can make a table using your data set in Qlik Sense and apply expressions and conditions on them. However, plan to make tables in such a way that you do not overload it with too many data and rows. <\/span><\/p>\n<p><span style=\"font-weight: 400\">If you have any queries or suggestions related to Qlik Sense Tables, leave a comment in the comment box below.<\/span><\/p>\n<p><strong>You may like &#8211;<\/strong><\/p>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlik-sense-managing-data\/\">Qlik Sense Managing Data<\/a><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Earlier, we discussed Qlik Sense KPI. In this tutorial, we will explore the most important element of visualizations i.e. the Qlik Sense Tables. However, in the internal logic of Qlik Sense, data is stored&#46;&#46;&#46;<\/p>\n","protected":false},"author":6,"featured_media":46195,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17408],"tags":[18053,18052,18049,18050,18051],"class_list":["post-46173","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-qlik-sense-tutorials","tag-exploring-tables","tag-properties-panel-in-qlik-sense-tables","tag-qlik-sense-tables","tag-tables-in-qlik-sense","tag-what-are-qlik-sense-tables"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Qlik Sense Tables - Exploring the Tables in Qlik Sense - DataFlair<\/title>\n<meta name=\"description\" content=\"Qlik Sense Tables - Learn how to create Table in Qlik Sense. Also, check properties panel of tables and exploring the tables\" \/>\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-tables\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Qlik Sense Tables - Exploring the Tables in Qlik Sense - DataFlair\" \/>\n<meta property=\"og:description\" content=\"Qlik Sense Tables - Learn how to create Table in Qlik Sense. Also, check properties panel of tables and exploring the tables\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/qlik-sense-tables\/\" \/>\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-23T06:13:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/Qlik-Sense-Tables-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 Tables - Exploring the Tables in Qlik Sense - DataFlair","description":"Qlik Sense Tables - Learn how to create Table in Qlik Sense. Also, check properties panel of tables and exploring the tables","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-tables\/","og_locale":"en_US","og_type":"article","og_title":"Qlik Sense Tables - Exploring the Tables in Qlik Sense - DataFlair","og_description":"Qlik Sense Tables - Learn how to create Table in Qlik Sense. Also, check properties panel of tables and exploring the tables","og_url":"https:\/\/data-flair.training\/blogs\/qlik-sense-tables\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-12-23T06:13:11+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/Qlik-Sense-Tables-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-tables\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-tables\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89"},"headline":"Qlik Sense Tables &#8211; Exploring the Tables in Qlik Sense","datePublished":"2018-12-23T06:13:11+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-tables\/"},"wordCount":1167,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-tables\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/Qlik-Sense-Tables-01.jpg","keywords":["Exploring Tables","Properties panel in Qlik Sense Tables","Qlik Sense tables","Tables in Qlik sense","What are Qlik Sense Tables"],"articleSection":["Qlik Sense Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/qlik-sense-tables\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-tables\/","url":"https:\/\/data-flair.training\/blogs\/qlik-sense-tables\/","name":"Qlik Sense Tables - Exploring the Tables in Qlik Sense - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-tables\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-tables\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/Qlik-Sense-Tables-01.jpg","datePublished":"2018-12-23T06:13:11+00:00","description":"Qlik Sense Tables - Learn how to create Table in Qlik Sense. Also, check properties panel of tables and exploring the tables","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-tables\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/qlik-sense-tables\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-tables\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/Qlik-Sense-Tables-01.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/Qlik-Sense-Tables-01.jpg","width":1200,"height":628,"caption":"Qlik Sense Tables - Exploring the Tables in Qlik Sense"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-tables\/#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 Tables &#8211; Exploring the Tables 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\/46173","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=46173"}],"version-history":[{"count":2,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/46173\/revisions"}],"predecessor-version":[{"id":46196,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/46173\/revisions\/46196"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/46195"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=46173"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=46173"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=46173"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}