Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
alematex
Partner
Partner

2 Dimension Bar Chart Sorting

Hi all:

I want to sort my Client Dimension and Type dimension by sum(Qty) in a bar chart in qlikview, I don't want script solution only inside chart if it's possible. Assume Qty is a calculated field.

Data:

ClientTypeQty
AGYa2
AGYb5
DMEOa3
DMEOb10
DMEOc6
DMEOd5
ZIHa4
ZIHb5
ZIHc8
GPOa9

Like this

graph.PNG

Thanks

1 Solution

Accepted Solutions
Gysbert_Wassenaar

Try a calculated dimension instead of Type: aggr(dual(Type,Sum(Qty)),Client,Type). Then set the sorting of that calculated dimension to Sort numerically, Descending.


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar

Try a calculated dimension instead of Type: aggr(dual(Type,Sum(Qty)),Client,Type). Then set the sorting of that calculated dimension to Sort numerically, Descending.


talk is cheap, supply exceeds demand

View solution in original post

alematex
Partner
Partner
Author

Thank you, this do the trick