Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
newqlik2017
Creator II
Creator II

Sorting in a chart (with drill down)

Hello,

  Here's my data set. On my chart I have a dimension as a cyclic drill down and am looking to sort the dimension columns (Unit & Status) both on ascending order except the Misc value should always be the last row.  A sample QVW is attached for your reference. Suggestions, please?

UnitStatusAmount
AgricultureAll50
AgricultureMisc200
AgricultureNone100
FinancialAll200
FinancialNone250
MiscMisc1000
SchoolAll100
SchoolMisc250
TechnologyNone500

Correct dimension sorting order (Misc value always needs to be at the last row):

   

UnitAmount
Agriculture350
Financial450
School350
Technology500
Misc1000

Incorrect dimension sorting order (Misc value always needs to be at the last row): So the order should be All, None, Misc):  

StatusAmount
All350
Misc1450
None850
1 Solution

Accepted Solutions
sunny_talwar

Sort the order of the dimensions within the Group itself

Capture.PNG

View solution in original post

2 Replies
sunny_talwar

Sort the order of the dimensions within the Group itself

Capture.PNG

newqlik2017
Creator II
Creator II
Author

Works perfect, thank you.

I also have another question, may be you could help

https://community.qlik.com/message/1439884#1439884

Retain default view of the chart when toggling between tabs