Discussion board where members can learn more about Qlik Sense App Development and Usage.
Below is my requirement:
I have a pivot table with Date in the row which by default is arranged in descending order.
I want an option to be available for user to select if they want it to be viewed as ascending or descending.
Say i can have a drop down : Ascending and Descending
If the user selects "Ascending" the date should be arranged in ascending
if the user selects "Descending" the date should be arranged in descending.
1. create an inline table [Sorting], with sorting Field, with Values: Ascending, Descending
LOAD * Inline [
2. on your pivot table, on the sorting area, uncheck all and put Date_field on top, with expression like this on Ascending:
Now you can use a listbox to show a drop down list (ascending/descending) to change the Date sorting.
Thank You Youssef!
This was very helpful
As soon as it is OK for you, don't forget to close the thread my marking the Correct and helpful answers.