Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
bhaveshm21
Contributor
Contributor

Issue while sorting by expression in trellis chart

Hi,

In my trellis bar chart  - I have two dimensions 1. Region & 2. Product and Expression 3. Sales  i.e. Sum(Sales).

I am trying to sort each chart from trellis based on expression value as per Products. But I can see by default it is sorted on the bases of combined (Total) value of Region & Product.

Is there any way by which I can sort by Products?  I am trying to avoid creating  3 separate charts.   

Expected Result - as per highlighted in Green

Chart A Should show product D then B, A ,C

Chart B - C, D, A, B

Chart C - A, C, D, B

 

Your help will be highly appreciated. 

Sorting.png

1 Reply
eddie_wagt
Partner - Creator III
Partner - Creator III

Hello,

Standard it will determine it's sorting order with a trellis chart by de total over all dimensions. You can solve this by replacing the dimension Product with a Dual function. See QVW for the solution.

Regards Eddie