Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Custom Sort in List Box

Hiya, I have some text fields denoting Periods in my data set. These are labels as follows:

Pre-Project

Q1 2012

Q2 2012

Q3 2012

Q4 2012

Q1 2013

I would like to custom sort them to they are in above order - but at present they won't do this (and either just go in load order or Q1 2012, Q1 2013 etc). Is there an expression I can use to sort these?

thanks

Tags (1)
1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: Custom Sort in List Box

It would be best to correct this in the script, by parsing in your periods as dates. dates have a numeric representation which you can use for sorting.

In the list box properties, you can also try a sort by expression:

=match( [Pre-Project], 'Q1 2012','Q2 2012','Q3 2012','Q4 2012','Q1 2013')

2 Replies
Highlighted
MVP
MVP

Re: Custom Sort in List Box

It would be best to correct this in the script, by parsing in your periods as dates. dates have a numeric representation which you can use for sorting.

In the list box properties, you can also try a sort by expression:

=match( [Pre-Project], 'Q1 2012','Q2 2012','Q3 2012','Q4 2012','Q1 2013')

Not applicable

Re: Custom Sort in List Box

Brilliant that expression has resolved it! Thanks a lot for your help.

Community Browser