topic Re: Month sort problem last 12 months in QlikView

Month sort problem last 12 months

rolandg1881 — Tue, 09 Mar 2021 08:06:29 GMT

Hi!

I have the problem if i want see data from the last twelve months that the months are not in the correct "sequence".

it starts in june 2020 and ends in Mai 2020. You can see it in the attachment.

Any idea whats wrong? I tried any things but nothing worked correctly .

in the diagramm for the last 6 months i can see it correct with the same settings?

Thank you!

Roland

NitinK7 — Tue, 09 Mar 2021 08:23:50 GMT

I think you missed file attachment , please attach your qvf

rolandg1881 — Tue, 09 Mar 2021 09:24:07 GMT

Ooops!

NitinK7 — Tue, 09 Mar 2021 10:10:08 GMT

Create a field in script by using

Num(Month(DateField)) as MonthNum;

Sort tab:

Expression : MonthNum

Expression: match(Month,'Jan','Feb','Mar' ...)

wildmatch(only({1}Month_field),'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec')

only({1})- with this it wont change the order.