Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Stacked Bar Chart Sorting

Can one sort the values (ascending or descending) for the yearly values in the following stacked bar chart and if so how can this be achieved?

Screen Shot 2015-11-23 at 21.52.16.png

The application is attached

1 Solution

Accepted Solutions
MarcoWedel

Hi,

maybe like this:

QlikCommunity_Thread_192638_Pic1.JPG

QlikCommunity_Thread_192638_Pic2.JPG

QlikCommunity_Thread_192638_Pic3.JPG

QlikCommunity_Thread_192638_Pic6.JPG

QlikCommunity_Thread_192638_Pic4.JPG

QlikCommunity_Thread_192638_Pic5.JPG

hope this helps

regards

Marco

View solution in original post

6 Replies
MarcoWedel

Hi,

maybe helpful:

Sort Stacked Chart by Y and 2nd Dimension

regards

Marco

Anonymous
Not applicable
Author

Thanks Marco for your response.  I am failing to implement your recommendation.  Can you kindly show me by example through the attached qvw document?

MarcoWedel

Hi,

maybe like this:

QlikCommunity_Thread_192638_Pic1.JPG

QlikCommunity_Thread_192638_Pic2.JPG

QlikCommunity_Thread_192638_Pic3.JPG

QlikCommunity_Thread_192638_Pic6.JPG

QlikCommunity_Thread_192638_Pic4.JPG

QlikCommunity_Thread_192638_Pic5.JPG

hope this helps

regards

Marco

Anonymous
Not applicable
Author

Thanks Marco, very helpful.  I have a full data set so my results will be different. I have an issue with the colors coming out on the year 2015 chart which are identical for three different items and there are identical colors within each stacked chart for the years 2012 and 2014 for different items:

Screen Shot 2015-11-24 at 03.17.44.png

Am i missing something?  Are there any specific property settings for the second expression

='Drug Name = '&[Drug Name]  ?

yhvijaya
Contributor
Contributor

Hi

Good day
How to achieve the same functionality in Qlik Sense
yhvijaya
Contributor
Contributor

Hi

Any one know how to achieve same functionality in qlik sense