2 Dimension Bar Chart Sorting

[alematex]

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:

Client	Type	Qty
AGY	a	2
AGY	b	5
DMEO	a	3
DMEO	b	10
DMEO	c	6
DMEO	d	5
ZIH	a	4
ZIH	b	5
ZIH	c	8
GPO	a	9

Like this

Thanks

[Gysbert_Wassenaar · Accepted solution]

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.

[alematex]

Thank you, this do the trick