Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Insider: SaaS capabilities for Data Integration and Analytics, May 25th! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
mkrabbani
Contributor II
Contributor II

How to sort bars for each dimension in chart

Hello everyone, I am new to QlikSense development and already searched for the solution here in the community but no luck. Anyway here is my scenario-

 

I have a bar chart with Year-Week dimension.

I have 3 measure value to show for each dimension value. For say these following three measure -

    SUM(field_1) //blue bar

    SUM(field_2) //yellow bar

    SUM(field_3) //red bar

 

Here is the sample output of 2 data point from Year-Week dimension-

mkrabbani_0-1640325599034.png

 

Now you can see, for 2021-W16 data point I have highest count for yellow then blue and then red. Now I would like to sort them for the Value. For other data point in the sample image is already in expected order by luck 🙂

 

Note: For each data point, that order can be different based on value/count.

 

Thanks in advance. 

Labels (2)
1 Solution

Accepted Solutions
Gysbert_Wassenaar

With a bit of trickery it's possible. See attached examplec1874887.png


talk is cheap, supply exceeds demand

View solution in original post

4 Replies
Gysbert_Wassenaar

With a bit of trickery it's possible. See attached examplec1874887.png


talk is cheap, supply exceeds demand
mkrabbani
Contributor II
Contributor II
Author

Thanks Gysbert for your answer, but unfortunately this tricks not working for me 😞 

Just to avoid confusion, I am using QlikSense.

Can you please check what I am doing wrong-

mkrabbani_0-1640350651313.png

 

Gysbert_Wassenaar

No, you check why it doesn't work for you. That's why I attached the Qlik Sense app in the first place.


talk is cheap, supply exceeds demand
mkrabbani
Contributor II
Contributor II
Author

Thanks for your help Gysbert. It worked the way you implemented things in the app.