topic Re: Sorting multi dimensional Bar Chart in QlikView

Sorting multi dimensional Bar Chart

Tue, 12 Aug 2014 06:46:03 GMT

HI,

Please take a look at the attached sample application. What I want to accomplish is to chart the top 10 zip codes based on the expression value sum(population) for year 2012. So, I tried the following sort expression in the Sort tab as you can see in the app:

=rank(aggr(sum({$<year={2012}>}population),year))

But it's not working. Can someone point me to the right direction.

Re: Sorting multi dimensional Bar Chart

amit_saini — Tue, 12 Aug 2014 06:50:55 GMT

Dennis,

Try something like this for top 10:

=aggr(if(rank(sum(Data))<=10, User),User)

Thanks,
AS

Re: Sorting multi dimensional Bar Chart

Tue, 12 Aug 2014 07:08:27 GMT

Hi amit,

Thanks for the reply. But, I am not sure if I follow your suggestion. Are you saying in my case to use this expression in the Sort tab:

=aggr(if(rank(sum(population<=10,year),year)

My chart displays the expression four times for each zip code in the x-axis (one for each year). I need to sort the x-axis (zip codes) based on the last year (2012) expression values.

Re: Sorting multi dimensional Bar Chart

amit_saini — Tue, 12 Aug 2014 07:13:34 GMT

Dennis ,

You have to use this concept as Calculated dimension and than expression.

Thanks,