Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

vkolasani
New Contributor III

Sorting Stacked Bar chart with Drill Down Group dimension

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.Screen Short Sorting.PNG

Thanks,

Venu

1 Solution

Accepted Solutions

Re: Sorting Stacked Bar chart with Drill Down Group dimension

Hi,

some similar solution using rank as calculated dimension:

QlikCommunity_Thread_229927_Pic1.JPG

QlikCommunity_Thread_229927_Pic2.JPG

hope this helps

regards

Marco

View solution in original post

7 Replies

Re: Sorting Stacked Bar chart with Drill Down Group dimension

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

Capture.PNG

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.

vkolasani
New Contributor III

Re: Sorting Stacked Bar chart with Drill Down Group dimension

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

kumarkp412
Contributor II

Re: Sorting Stacked Bar chart with Drill Down Group dimension

Hi Venu,

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

Thanks

Kumar KVP

vkolasani
New Contributor III

Re: Sorting Stacked Bar chart with Drill Down Group dimension

Kumar,

Thanks for your efforts!

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

Thanks,

Venu

othniel2014
New Contributor III

Re: Sorting Stacked Bar chart with Drill Down Group dimension

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

Hi,

some similar solution using rank as calculated dimension:

QlikCommunity_Thread_229927_Pic1.JPG

QlikCommunity_Thread_229927_Pic2.JPG

hope this helps

regards

Marco

View solution in original post

Re: Sorting Stacked Bar chart with Drill Down Group dimension