topic Re: 2 Dimension Bar Chart Sorting in QlikView

2 Dimension Bar Chart Sorting

alematex — Mon, 07 Dec 2015 18:05:05 GMT

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

Re: 2 Dimension Bar Chart Sorting

Gysbert_Wassenaar — Mon, 07 Dec 2015 19:04:01 GMT

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.

Re: 2 Dimension Bar Chart Sorting

alematex — Mon, 07 Dec 2015 22:52:54 GMT

Thank you, this do the trick