Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

sorting in the list box based on another field

In a list box, I am displaying month field and I want to sort according to another file (say period). These two fields are from the same table and the corresponding is as below:

 

Month   Period

 

Oct          1

 

Nov         2

 

Dec         3

 

Jan          4

 

Feb          5

 

Mar          6

 

Apr          7

 

May         8

 

Jun          9

 

Jul           10

 

Aug          11

 

Sep           12

 

So in the sort field, I have used ascending expression =Period . but the result is not as expected. Any idea? thanks

 

1 Solution

Accepted Solutions
Highlighted
Creator II
Creator II

Re: sorting in the list box based on another field

Hi

Please find the attached application. its working in that

View solution in original post

4 Replies
Highlighted
Specialist
Specialist

Re: sorting in the list box based on another field

Hello!

Can you please share the result? Other options of sorting like "State" or "Text" is off?

Highlighted
Creator II
Creator II

Re: sorting in the list box based on another field

Hi

Please find the attached application. its working in that

View solution in original post

Highlighted

Re: sorting in the list box based on another field

What you mean "not as expected", What are you expecting to see after sorting option enabled?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Creator III
Creator III

Re: sorting in the list box based on another field

I am expecting the display would be Oct, Nov, Dec...etc. and the result is as below:

sorting.PNG