topic Set different "Sort by" for drill down chart in QlikView

Set different "Sort by" for drill down chart

Anonymous — Fri, 29 Aug 2014 14:12:24 GMT

Hi guys,

Can I set different "sort by"s for different layers in a drill down chart?

For example,

I have a drill down group with four layers as a dimension.

1. Year

2. Agent

3. Order Number

The express is: sum(sales)

Of course I want the "Year" to be in acceding order. But I want the "Agent" and "Order Number" to be in descending order by "Y value" which is the sum of the sales.

How can I achieve this?

Thanks,

Lynn

Re: Set different "Sort by" for drill down chart

giakoum — Fri, 29 Aug 2014 14:14:36 GMT

Re: Set different "Sort by" for drill down chart

Anonymous — Fri, 29 Aug 2014 14:22:13 GMT

Thanks, but there is no option for "Y value" descending....

Re: Set different "Sort by" for drill down chart

giakoum — Fri, 29 Aug 2014 14:27:13 GMT

true, but you can use expression instead. The Y value is actually your 1st expression in the table, so you can replicate it here.

Re: Set different "Sort by" for drill down chart

JonnyPoole — Fri, 29 Aug 2014 14:27:38 GMT

For the levels you need 'Y Value descending' , select expression and enter your expression sum(Sales) again . Descending.

Re: Set different "Sort by" for drill down chart

Anonymous — Fri, 29 Aug 2014 14:41:12 GMT

Great!! It works. You are awesome!