Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

How to fix sequence of months in LIST BOX?

Basically, I want to fix sequence according to financial months

1. I tried it using wildmatch,match

2.Also, tried with if else condition.

But nothing is working.Please suggest me.

1 Solution

Accepted Solutions
Highlighted
Anonymous
Not applicable

sort by expression:

FINALMONTHFIELD

or perhaps:

min(FINALMONTHFIELD)

View solution in original post

7 Replies
Highlighted
Anonymous
Not applicable

sort by expression:

FINALMONTHFIELD

or perhaps:

min(FINALMONTHFIELD)

View solution in original post

Highlighted
Not applicable

Thanks Robin.

Highlighted
Anonymous
Not applicable

if my answer is correct, then please mark it as correct.

Highlighted
Specialist
Specialist

Hi Shubham,

There are various ways you can achieve this:

Put below in sort by expression.

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

Set the arrangement to Ascending

note: you can also change the sequence of Jan,Feb,Mar,etc by changing the sequence in Match function.

Regards,

Pankaj

Highlighted
Not applicable

Thanks Robin.It's working.

Highlighted
Not applicable

No Pankaj.That's not working.Actually, I already tried it.

Thanks.

Highlighted
Specialist
Specialist

Hi Shubham,

It might be your month name is not matching.

To check that put below expression in list box and see if you get a list of values ranging from 1-12.

Match(Month,'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec')

Regards,

Pankaj