Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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