topic Order for month in QlikView

Order for month

Wed, 06 Aug 2014 05:53:07 GMT

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

Re: Order for month

amit_saini — Wed, 06 Aug 2014 05:59:34 GMT

Sanjeev,

See the attachment.

Sort--> should be Auto Ascending.

Thanks,
AS

Re: Order for month

ashfaq_haseeb — Wed, 06 Aug 2014 06:01:56 GMT

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

Re: Order for month

mdmukramali — Wed, 06 Aug 2014 06:15:19 GMT

Dear,

Thanks,

Mukram

Re: Order for month

Wed, 06 Aug 2014 06:17:15 GMT

thanks amit it is working

Re: Order for month

Wed, 06 Aug 2014 06:18:18 GMT

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

Re: Order for month

amit_saini — Wed, 06 Aug 2014 06:19:09 GMT

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

Thanks,

Re: Order for month

Wed, 06 Aug 2014 06:23:38 GMT

hi angad it is working ,,thanks for that

Re: Order for month

Wed, 06 Aug 2014 06:25:00 GMT

hi amit how can i close this??

Re: Order for month

Wed, 06 Aug 2014 06:25:14 GMT

hi sanjeev reedy please mark as answered

Re: Order for month

ashfaq_haseeb — Wed, 06 Aug 2014 06:26:42 GMT

did you try my solution?

Regards

ASHFAQ

Re: Order for month

Wed, 06 Aug 2014 06:29:35 GMT

yes but is is not working

Re: Order for month

amit_saini — Wed, 06 Aug 2014 06:29:57 GMT

Select as Correct Answer.

Thanks,
AS

Re: Order for month

ashfaq_haseeb — Wed, 06 Aug 2014 06:32:26 GMT

I have application attache

Have a look

Re: Re: Order for month

aveeeeeee7en — Wed, 06 Aug 2014 06:48:30 GMT

Hi Venkatesh

There is a solution for this. You don't need to create Inline Table and Number field for it.

Do it in the Sort Expression option. Like this:

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

and also do other changes

See the Snapshot below:

Hope that helps.

See the Attachment.

You can also follow Angad's Approach.

Regards

Aviral Nag

Re: Order for month

Wed, 06 Aug 2014 15:01:31 GMT

Hi Amit it is working but if i make selections on Month list box order is changing now is there any solution for that???

Re: Order for month

Wed, 06 Aug 2014 15:02:30 GMT

Hi Angad it is working but if i make selections on Month list box order is changing now is there any solution for that???

Re: Order for month

ashfaq_haseeb — Wed, 06 Aug 2014 15:24:26 GMT

Hi,

Have a look at my app.

Download it again

I fixed it for you.

Regards

ASHFAQ

Re: Order for month

Wed, 06 Aug 2014 15:34:51 GMT

Thanks for that Ashfaq

Re: Order for month

ashfaq_haseeb — Wed, 06 Aug 2014 15:36:28 GMT

If if fixed then mark relevant answer.

Regards

ASHFAQ