Skip to main content
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

class interval sorting

I have created the following chart using the class function:

Screen Shot 2016-03-16 at 15.13.17.png

The calculated dimension and expression for the table are as follows;

Screen Shot 2016-03-16 at 15.13.42.png

Screen Shot 2016-03-16 at 15.14.13.png

How can the table be sorted properly starting with lower age intervals:

0 - 5

5 - 10

10 - 15 etc

regards.

Chris

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

Use this expression as calculated dimension

=Dual(Replace(Aggr(Class(Count(Distinct PortfolioAge),5), MCAZApplicant), '<= x <', ' -'),Aggr(Class(Count(Distinct PortfolioAge),5), MCAZApplicant))

Go to sort tab and sort by numeric Value.

View solution in original post

4 Replies
MK_QSL
MVP
MVP

Use this expression as calculated dimension

=Dual(Replace(Aggr(Class(Count(Distinct PortfolioAge),5), MCAZApplicant), '<= x <', ' -'),Aggr(Class(Count(Distinct PortfolioAge),5), MCAZApplicant))

Go to sort tab and sort by numeric Value.

sunny_talwar

Can you try using Dual() function:

=Dual(Replace(Aggr(Class(Count(DISTINCT PortfolioAge), 5), MCAZApplicant), '<= x <', ' - '), Aggr(Class(Count(DISTINCT PortfolioAge), 5), MCAZApplicant))

and then sort your dimension numeric ascending.

Anonymous
Not applicable
Author

Many thanks Manish

Anonymous
Not applicable
Author

Thank you Sunny