MonthYear Sorting According to Company Calendar Year

[#1]

Hi Everyone,

A noob here for QLIKVIEW. I have a requirement to compare current year(selection) vs. previous year. But the problem is the sorting not in order.

Our calendar year is from APRIL - MARCH the ff year. This is working for single year selection only.

Attached is the actual output. Hope someone can help the noob.

Thanks.

kramSe

[#2]

Goto Sort tab

Use this expression:

Date(Date#(YearMonth,'YYYY-MM'),'MM')

[#3]

It will sort Year and Month. I wanted to sort MMYYYY according to Company's Calendar year.

042013

052013

062013

072013

082013

If compared to previous year. It will be sorted like this.

042013

042012

052013

052012

062013

062012

072013

072012

082013

thanks you

[Anonymous]

Hi,

You can sort this by MonthNo. In sort tab, add expression Min(MonthNo). Or you can use dual function and replace dimension with "Dual(YearMonth, MonthNo)"

Hope it helps you.

Thanks

[#5]

try this

Date(Date#(YearMonth,'YYYY-MM'),'MMYYYY')

[sasikanth]

hi

one way is there i am not sure is it correct or not try once

use match() function

chart properties-->sort-->expression--

write like

=match(monthyear,'042013','42012','052013','052012',............)

like this it will sort according to the order that you want

[#7]

Thanks everyone. I already manage to look for solutions.

It has to do with APPLYMAP and sort on the table created.