Discussion board where members can get started with Qlik Sense.
I'm using a pivot table and have a question about sorting. Here is a screenshot of the table, where I'm sorting by Agmnt ID, Obligation Date and Unit Location:
As you can see the date "6/30/2020" has two obligations, one which has been 'Fufilled' (by "Ashland"0 and one which has not (and therefore is null).
My question is, how can I get the records to sort so that "Ashland" is listed first, and the null field is listed second?
I thought it would be easy to just go into the sort panel for the "unit Location" field and sort alphabetically as shown below, but it does not affect the sort sequence:
Thanks for any help or ideas anyone can offer!
Solved! Go to Solution.
The Location field is actually 'Unit Location Dim', and when I use the following expression, it is not populating the field with the correct location information to match with the Agreement ID or fulfilled obligation:
In case it is helpful, here is the expression in my script editor that defines Unit Location:
Dual("Unit Location", AutoNumber("Unit Location"&"Address Line 1")) as "Unit Location Dim",
Yes, I have tried that. As a matter of fact, I added in a numeric unique identifier (PS#), and it doesn't acknowledge the desirable sort even with that field in the table.
But, back to your question, I have tried sorting numerically on the 'Unit Location" field as follows, and do not get the desired result: