topic Re: Distinct dates from latest to oldest as dynamic values for variable input in App Development

Distinct dates from latest to oldest as dynamic values for variable input

Denzyl — Mon, 29 Aug 2022 08:11:44 GMT

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?

Re: Distinct dates from latest to oldest as dynamic values for variable input

Filippo_Nicolussi_P — Mon, 29 Aug 2022 10:09:32 GMT

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 ?

Re: Distinct dates from latest to oldest as dynamic values for variable input

Denzyl — Mon, 29 Aug 2022 12:12:41 GMT

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])