topic Re: Qlik sense sort by expression asc/desc depending on filter in App Development

Qlik sense sort by expression asc/desc depending on filter

MatsR — Tue, 15 Apr 2025 11:31:53 GMT

Hello all, I have a bar chart which contains YYYYMM on the x-axis which i want to sort asc/desc depending on how many months which are filtered.

I have a filter containing YYYYMM, if the user selects 15 months or less I would like to sort the x-axis ascending othervise descending. Is this possible?

Br Mats

Re: Qlik sense sort by expression asc/desc depending on filter

rwunderlich — Tue, 15 Apr 2025 14:41:03 GMT

I think the approach would be to set the sort direction to "ascending" and negate the value in your sort expression. A sort expression like:

if(Count(Distinct MonthYear) <= 15, MonthYear, -MonthYear)

-Rob

Re: Qlik sense sort by expression asc/desc depending on filter

BrandonFontes — Tue, 15 Apr 2025 17:32:16 GMT

Is that what you need?

Re: Qlik sense sort by expression asc/desc depending on filter

MatsR — Wed, 16 Apr 2025 07:11:46 GMT

Thanks for your reply, thats not quite what i'm looking for.

Re: Qlik sense sort by expression asc/desc depending on filter

MatsR — Wed, 16 Apr 2025 07:16:26 GMT

Thanks for your reply, yes this seems to what Im looking for, I cant get it to work though. It seems that the if condition always is true regardless how many months i choose. I i switch the '-' to the first MonthYear the sort order changes so I have to look into what Im doing wrong. Thanks for your help.