Qlik sense sort by expression asc/desc depending on filter

[MatsR]

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

[rwunderlich]

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

[BrandonFontes]

Is that what you need?

[MatsR]

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

[MatsR]

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.