From the course: Qlik Sense Essential Training

Unlock the full course today

Join today to access over 22,500 courses taught by industry experts or purchase this course individually.

Change table field number formatting

Change table field number formatting - Qlik Sense Tutorial

From the course: Qlik Sense Essential Training

Start my 1-month free trial

Change table field number formatting

- [Instructor] Qlik Sense can identify the data type contained within table columns. Each type has an associated format but you can edit that format if you want. In this movie, I will show you how to change and edit the data format assigned to a column. I have created a table based on data in the order details Excel Workbook that I'm drawing on for the majority of movies and the scores. Here, you see that I have a table with the customer's full name, the state in which they reside, and the sum total of all of their orders. I also have a grand total at the bottom. However, something to note about the formatting of the values in the sum of order total column, is that we have an inconsistent number of digits to the right of the decimal point. So for the first item we have .95, all good. For the second, we have 1671 with no digits to the right of the decimal point. And then in the number of cases below, starting with 83,201.5, we have only one number to the right of the decimal point…

Contents