Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vkolasani
Contributor III
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
MarcoWedel

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
sunny_talwar

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
Contributor III
Contributor III
Author

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
Creator II
Creator II

Hi Venu,

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

Thanks

Kumar KVP

vkolasani
Contributor III
Contributor III
Author

Kumar,

Thanks for your efforts!

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

Thanks,

Venu

othniel2014
Contributor III
Contributor III

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)

               )

          )

     )

)

MarcoWedel

Hi,

some similar solution using rank as calculated dimension:

QlikCommunity_Thread_229927_Pic1.JPG

QlikCommunity_Thread_229927_Pic2.JPG

hope this helps

regards

Marco