Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
GraceGao
Creator
Creator

sorting problem

Hi Experts

i have bar chart, dimension is master item dimension can drill down called product category, drill down to product group.

and measure is %sales vs last year. i would like to sorting bar chart  by the current year's sales not %sales vs last year.

and don't display current sales in the bar chart. i already set product category sorting by expression. however , it is working in product category, it is not working when i drill down to product group.  is there any way to realize the sorting problem? 

Thanks in advance. 

3 Replies
ChennaiahNallani
Creator III
Creator III

 

Select other dimensions in the dropdown and give the same expression which is you give to product category

clipboard_image_0.png

lironbaram
Partner - Master III
Partner - Master III

hi 

if you use a drill down master dimension 

than you can set the sort for each level of the dimension 

in the picture below , you can select the field from the drill down dimension ,in the  box were is written Line Desc 1

sort.png

GraceGao
Creator
Creator
Author

Dear Lironbbaram

Thanks so much for your reply, solved my problem.