topic Re: Month disordering !! in QlikView

Month disordering !!

nikhilgarg — Mon, 29 Sep 2014 06:07:41 GMT

HEy,

I have used Month field and used a list box but my months are not coming in Jan-Dec order. They are coming in A-Z order.

What to do , please help.

Thanks

Re: Month disordering !!

sushil353 — Mon, 29 Sep 2014 06:09:58 GMT

Hi,

See if this can help you : Sorting in qlikview

HTH

Sushil

Re: Month disordering !!

sushil353 — Mon, 29 Sep 2014 06:12:21 GMT

Hi,

Also you can write in sorting > Exrpession

=Pick(Match(Monthfield,'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec',1,2,3,4,5,6,7,8,9,10,11,12)

Re: Month disordering !!

sasikanth — Mon, 29 Sep 2014 06:12:47 GMT

try to check the option

Load Order

if not

then use match function

Match(<Month-Field>,'Jan','Feb','Mar',............................)

in sort tab Expression

Re: Month disordering !!

nikhilgarg — Mon, 29 Sep 2014 06:25:18 GMT

Hey ,

this doesnot works....

Re: Month disordering !!

nikhilgarg — Mon, 29 Sep 2014 06:27:15 GMT

Hey,

MAtch function works but problem is Before jan it is showing July.

I mean:

July,Jan,Feb..... Jun , Aug....Dec

What to do now??

Re: Month disordering !!

sasikanth — Mon, 29 Sep 2014 06:29:29 GMT

then please check the spell once in your backend make sure that same is there in your expression

may be issue with cap/small letter

Re: Month disordering !!

nikhilgarg — Mon, 29 Sep 2014 06:32:55 GMT

HEy,

I didnot get you. What you wana say ??

Re: Month disordering !!

sushil353 — Mon, 29 Sep 2014 06:33:54 GMT

Hi,

attach some screenshot or some sample data.

Re: Month disordering !!

deepakqlikview_123 — Mon, 29 Sep 2014 06:39:49 GMT

Go to Sort Tab

Select Month

Write below in expression =Date#(Month,'MMM')

now you can sort by Numeric Ascending or Descending Order

Re: Month disordering !!

sasikanth — Mon, 29 Sep 2014 06:40:16 GMT

plese check the spelling of 'july'
filed values names should also match in Match()function then only it will reflect the correct order

E.g:

MonthFiled

Jan

Feb

Mar

April

May

June

July

Then you have to wrrite like

Match(MonthFiled,'Jan','Feb','Mar'.....)

Exactly same as above its case sensitive

Re: Month disordering !!

nikhilgarg — Mon, 29 Sep 2014 06:45:25 GMT

Hey,

Thankx buddy.

it works.

Re: Month disordering !!

nikhilgarg — Mon, 29 Sep 2014 06:47:57 GMT

Hey,

BUt can you tell em how the following works??

I did not get the working...

Match(Month,'Jan','Feb','Mar','Apr','May','Jun','July','Aug','Sep','Oct','Nov','Dec',1,2,3,4,5,6,7,8,9,10,11,12)

Re: Month disordering !!

Mon, 29 Sep 2014 06:49:28 GMT

Hi Nikhil, Please see attached file, you can use the sort option and apply the formula. See the attached file.