topic Re: Sorting Stacked Bar chart with Drill Down Group dimension in QlikView

Sorting Stacked Bar chart with Drill Down Group dimension

vkolasani — Mon, 22 Aug 2016 14:25:17 GMT

Hello Experts,

I am trying to get the proper sorting for the stacked bars with the drill down group dimension based on the sales either descending or ascending.

Sorting works properly with the dimension, however when I tried to add the Drill Down group dimension it's not working as expected.

Thanks,

Venu

Re: Sorting Stacked Bar chart with Drill Down Group dimension

sunny_talwar — Mon, 22 Aug 2016 14:38:30 GMT

Have you tried giving a sort order for each of your dimension within the Group?

Or you can override the sort by dimension (by checking the box at the bottom of the Sort tab for the chart) and select sort by y-value.

Re: Sorting Stacked Bar chart with Drill Down Group dimension

vkolasani — Mon, 22 Aug 2016 15:16:41 GMT

Sunny,

Thanks for the reply!

The problem is with the Region sorting order on the stacked bar not the category/sub category drill down dimension.

Example:

For Technology category sorting of the Region stacked bar should be East,West, Central and South

Venu

Re: Sorting Stacked Bar chart with Drill Down Group dimension

kumarkp412 — Mon, 22 Aug 2016 16:44:33 GMT

Hi Venu,

With some messing about it can be done. See attached qvw.

Thanks

Kumar KVP

Re: Sorting Stacked Bar chart with Drill Down Group dimension

vkolasani — Mon, 22 Aug 2016 17:36:47 GMT

Kumar,

Thanks for your efforts!

It is so unfortunate we have to really mess up to get this done.

Thanks,

Venu

Re: Sorting Stacked Bar chart with Drill Down Group dimension

othniel2014 — Mon, 22 Aug 2016 20:08:49 GMT

In Expression Sort of Region

add

if(Region = 'East',

Dual('East',1),

if(Region = 'West',

Dual('West',2),

if(Region = 'Central',

Dual('Central',3),

if(Region = 'South',

Dual('South',4)

)

Re: Sorting Stacked Bar chart with Drill Down Group dimension

MarcoWedel — Tue, 23 Aug 2016 00:21:02 GMT

Hi,

some similar solution using rank as calculated dimension:

hope this helps

regards

Marco

Re: Sorting Stacked Bar chart with Drill Down Group dimension

MarcoWedel — Wed, 24 Aug 2016 00:07:27 GMT

maybe also helpful:

Stacked Bar Chart Sorting

Sort Stacked Chart by Y and 2nd Dimension

regards

Marco