topic Re: Sort months in ascending order when displaying last 24 months data in QlikView

Sort months in ascending order when displaying last 24 months data

wendytham — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

i would like to show last 24 months based on current month.

The below expression works well, but the month order is not sort in ascending order, how to fix this problem?

Please assist. Thank you.

=if(((MakeDate(Year,Month) < MonthStart(Today())) and (MakeDate(Year,Month)

>= AddMonths(MonthStart(Today()),-24))),Month(MakeDate(2000, Month, 1)) & ' ' & Year)

olivierrobin — Thu, 26 Jul 2018 08:16:15 GMT

hello

in your graph, you can sort the dimension based on an expression

you cans use something like Year*100+Month

jyothish8807 — Thu, 26 Jul 2018 08:28:45 GMT

You can try like this as well:

=if(((MakeDate(Year,Month) < MonthStart(Today())) and (MakeDate(Year,Month)

>= AddMonths(MonthStart(Today()),-24))),date(date#(Month(MakeDate(2000, Month, 1)) & ' ' & Year,'MMM YYYY'),'MMM YYYY'))

Then use sort option.

Br,

MindaugasBacius — Thu, 26 Jul 2018 08:32:41 GMT

What about this Sort Properties?