Every data source is organized into columns, each of which holds a specific data point. You can change the order of those columns, which are also called fields, within your app to emphasize the points you want to make.
- [Instructor] Every data source is organized in the columns, each of which holds a specific data point. You can change the order of those columns, which are also called fields, within your app to emphasize the points that you want to make. In this movie I will show you how to add, re-order, rename and delete fields within a table. I have created an app with a single sheet, and on that sheet I have a table that displays a customer's name, the state they're from, and the sum of all of their orders across the entire data set.
Let's say that I want to add another field to my data. To do that I can go up to the Edit Sheet button and click that, and then within the properties panel I can go down beneath columns under data, and click add column. You might have to scroll down a bit based on the state of your particular application, but for me I'll go ahead and click add column. I want to add a dimension which is descriptive, as opposed to a measure which is quantitative, so I'll click dimension, and let's say that I want to add customer number, and even though it is a number in this case it is a description and not something you would add or take an average of.
So I'll click CustNum and the field appears within the body of the table. And I'll just drag on the side to resize the table so that we can see it. The customer number field is closely associated by reference to the customer's full name. So let's say that I wanted to move customer number, so that it is just one column to the right of customer's full name. Over in the data section of the properties panel I can move the mouse pointer over the rectangle of dots at the right side of the CustNum field header.
You can see that that's called the move button, and then I will drag CustNum up until it's above state and when I release we can see that the value appears to the right of the customer's full name field. Also note, however, that CustNum doesn't appear in full in the body of the table. In other words, the field name is too long for the space allotted to it. So for that we need to change that field's label. Again, over in the properties panel under data I will click CustNum, and in this case I will click the header itself so that I get a display of the options available.
I have the label here just below field, and I'll click in that box and just typ N-U-M, short for number. Right parentheses and we can see that it now appears as N-U-M within the table. If I want to delete a field entirely, in this case I figure the customer number really isn't that important, then I can go over to the data section of the properties pane, right-click the num field header, and click delete.
And that is how you add, re-order, rename and delete table fields
- Navigating the Qlik Sense user interface
- Managing data sources and tables
- Creating an app from a data source
- Managing Qlik Sense sheets
- Exporting Qlik Sense data to Excel
- Creating bar, line, pie, and scatter plot charts
- Creating charts, text, and images for dashboards
- Creating and manipulating PivotTables
- Sorting and filtering chart and table data