Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to create a variable input to display all distinct values in [date] column from latest to oldest. Currently I am able to display from oldest to latest.
Code used to create options above:
=CONCAT(DISTINCT [date.autoCalendar.YearMonth],'|',[date.autoCalendar.YearMonth])
How would I be able to flip the order?
Could the thread here https://community.qlik.com/t5/QlikView-App-Dev/Concat-a-field-with-a-sort-on-expression/td-p/279063 help somehow for an expression on the only date.autoCalendar ?
Could the thread here https://community.qlik.com/t5/QlikView-App-Dev/Concat-a-field-with-a-sort-on-expression/td-p/279063 help somehow for an expression on the only date.autoCalendar ?
All I had to do was to add a minus sign to the sort-weight parameter to reverse it.
=CONCAT(DISTINCT [date.autoCalendar.YearMonth],'|',-[date.autoCalendar.YearMonth])