topic Re: Sort by Expression in QlikView

Sort by Expression

alec1982 — Thu, 02 Aug 2012 16:45:12 GMT

Hi,

I have a bar chart with one dimension and 5 expressions.

I am trying to sort by Y Descending but it is not working....

My dimension is AA

and my Expressions are Sum(Q1), Sum(Q2), Sum(Q3), Sum(Q4), Sum(Q5)

Anybody has suggestions.

Thanks,

Alec,

Re: Sort by Expression

MayilVahanan — Thu, 02 Aug 2012 17:13:09 GMT

Can you post a sample file?

Re: Sort by Expression

ericcosmai — Thu, 02 Aug 2012 17:14:03 GMT

Hi Alec.

In this case, as you have 5 expressions, when you chose to sort by the Y Descending, you are saying to the chart to sort by the first expression it finds on your list of expression. Follow an aplication like example.

Hope it helps.

Regards.

Re: Sort by Expression

alec1982 — Thu, 02 Aug 2012 17:35:37 GMT

Hi,

Thanks for the replay.

The bars are stacked. so Anybody knows how can sort by all expressios together

Thxs,

Re: Sort by Expression

swuehl — Thu, 02 Aug 2012 17:45:17 GMT

Try a sort by expression with expression

=rangesum( Sum(Q1), Sum(Q2), Sum(Q3), Sum(Q4), Sum(Q5) )

Re: Sort by Expression

ToniKautto — Thu, 02 Aug 2012 17:49:30 GMT

I dont really understand the question. Are you saying that you want to sort your dimension by the total sum of all expressions?

Is this the sorting expression you are looking for?

aggr( Sum(Q1)+Sum(Q2)+Sum(Q3)+Sum(Q4)+Sum(Q5) , AA )

Or maybe this could be an option?

aggr( Sum(Q1 + Q2 + Q3 + Q4 + Q5) , AA )

Re: Sort by Expression

alec1982 — Thu, 02 Aug 2012 17:56:03 GMT

Hi,

Using this method i am getting red line under AA

Thanks,