Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
nihhalmca
Specialist II
Specialist II

Sorting issue in bar chart

Hi All -

Getting sort issue in bar char while dealing with alternate dimensions and alternate measures.

For example:

Stack: Region (Alternate Dimensions: Country etc)

Bar: Product  (Alternate Dimensions: Country etc)

Measure: Sales - (Alternate Measures: Revenue etc)

Need to sort chart based on measures (desc order). However unable to do it.

Actually it is possible if we go with one alternate dimension or measure instead of both alternates.

Thank you.

Labels (3)
2 Replies
Or
MVP
MVP

For sorting the bars based on size, see:

https://help.qlik.com/en-US/video/gIaSrl3jlxE

For internal sorting of a bar within a stacked chart, see:

https://community.qlik.com/t5/New-to-Qlik-Sense/Sorting-inner-segments-of-Stacked-Bar/td-p/1436519

Note that for alternatives, I believe you would need to apply the sort to each one individually (which required you bring each one up front, set the order, and then switch it back to alternative).

vikasmahajan

Hi,

Did you try this custom sorting option 

https://community.qlik.com/t5/New-to-Qlik-Sense/Custom-Sort/td-p/1666109

https://community.qlik.com/t5/QlikView-App-Dev/Custom-Sort-Order/m-p/765933

 

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.