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

[amit_saini · Accepted solution]

Sanjeev,

See the attachment.

Sort--> should be Auto Ascending.

Thanks,
AS

[ashfaq_haseeb]

Hi,

Use below in sort expression.

=match(month,'jan','feb','mar','apr','may','jun','jul','aug','sep','oct','nov','dec')

Have a look at attached document.

Regards

ASHFAQ

[mdmukramali]

Dear,

Thanks,

Mukram

[#5]

thanks amit it is working

[#6]

Hello,

Please use below as the expression in sort:

=only({<year=>}number)

Moreover, the best way is to create a master calendar and then attach the data date fields to it.

Please find PFA, hope it was helpful.

Thanks,

Angad

[amit_saini]

Happy to help you, Kindly close the thread by marking Correct or Helpful answer .

Thanks,

AS

[#8]

hi angad it is working ,,thanks for that

[#9]

hi amit how can i close this??

[#10]

hi  sanjeev reedy please mark as answered