topic Re: Sorting Problem ? in QlikView

Sorting Problem ?

madhubabum — Wed, 10 Jun 2015 12:47:22 GMT

Hai all

I got Two exp in a BarChart . I am not getting a proper descending order ..How to achieve this.

Example : Sum(Profit),Sum(Discount) in expressions

Profit_Center as a Dimension .

Thank You .

Madhu Babu

sunny_talwar — Wed, 10 Jun 2015 12:51:41 GMT

Are you trying to sort it by descending order of Profit or Discount?

Have you tried sorting by the Y-value Descending?

buzzy996 — Wed, 10 Jun 2015 12:54:19 GMT

try tis,

avinashelite — Wed, 10 Jun 2015 12:55:14 GMT

Hi Madhu,

try with the expression option in the sort tab, there you can write the sorting order you want .

Try with sum(Profit) or sum(Discount)

madhubabum — Wed, 10 Jun 2015 13:13:03 GMT

Hi All ,

I don't have Y-Value option in Sorting Tab...

avinashelite — Wed, 10 Jun 2015 13:14:35 GMT

can you please share your app

awhitfield — Wed, 10 Jun 2015 13:24:39 GMT

Hi Madhu,

try this

In the sort tab, click on your profit centre dimension (MAR?) and tick expression > ascending and expression as Sum(Profit)

Andy

jonas_rezende — Wed, 10 Jun 2015 14:30:12 GMT

Hi.

Do steps follow:

In sort tab, dimension area , choice the order of classification, utilize Promote and Demote;
In first dimension, Expression checkbox, insert the Sum(Profit) or Sum(Discount);
After, remove others checkbox;
Finally, click Ok.

Hope this help!