Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
nikhilgarg
Specialist
Specialist

Month disordering !!

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

1 Solution

Accepted Solutions
sasikanth
Specialist III
Specialist III

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

View solution in original post

13 Replies
sushil353
Master II
Master II

Hi,

See if this can help you : Sorting in qlikview

HTH

Sushil

sushil353
Master II
Master II

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)

sasikanth
Specialist III
Specialist III

try to check the option

Load Order

if not

then use match function

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

in sort tab Expression

nikhilgarg
Specialist
Specialist
Author

Hey ,

this doesnot works....

nikhilgarg
Specialist
Specialist
Author

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??

sasikanth
Specialist III
Specialist III

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

nikhilgarg
Specialist
Specialist
Author

HEy,

I didnot get you. What you wana say ??

sushil353
Master II
Master II

Hi,

attach some screenshot or some sample data.

deepakqlikview_123
Specialist
Specialist

Go to Sort Tab

Select Month

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

now you can sort by Numeric Ascending or Descending Order