Order for month

[#1]

hi all,

i have created new qv qocument with fields month,year,reportname,path.Here if i select year as 2013 then month order is displaying in jan,feb,mar...nov,dec.but if i select 2014 month order is changing with selections like dec,nov,jan,feb,mar.i need show month order as if we select 2014 then jan,feb,mar..nov,dec.

i have created in script inline for month along with number and i change in sort tab expression=number.

it is working for 2013 but not for 2014 .i am attaching qlikview document  please check

[#2]

Hello Sanjeev,

Use: only({<year=, name=>}number) as Expression and Ascending.

The best way should be to create a master calendar.

Thanks,

Angad

[#3]

Hi Angad it is working thanks

[#4]

Thanks for that Angad but if i select name month order is not changing but if i select next filter report name then month order is changing again. Any solution for that??

[#5]

chk the attached file.... it is working fine

!

[#6]

Then please use below as expression:

only({1}number)

Hope this was helpful.

Thanks,

Singh