topic Re: class interval sorting in QlikView

class interval sorting

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I have created the following chart using the class function:

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

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

0 - 5

5 - 10

10 - 15 etc

regards.

Chris

Re: class interval sorting

MK_QSL — Wed, 16 Mar 2016 13:34:48 GMT

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.

Re: class interval sorting

sunny_talwar — Wed, 16 Mar 2016 13:36:08 GMT

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.

Re: class interval sorting

Anonymous — Wed, 16 Mar 2016 13:41:28 GMT

Many thanks Manish

Re: class interval sorting

Anonymous — Wed, 16 Mar 2016 13:41:45 GMT

Thank you Sunny