Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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