topic Re: sorting stacked bar chart with 3 dimensions in QlikView

sorting stacked bar chart with 3 dimensions

Thu, 24 Mar 2016 15:13:55 GMT

Hello,

I have a problem to sort the bar segments within a stacked bar chart.

Attached you can see my bar chart and a table for the explanation.

What i would reach is that within each year the bars are sorted according the total of the group (in my example CNG, SSC, TSC, ACSV because the totals are 514/292/146/88) and within each group the sorting should be the single count value. This means within CNG i would like to have first the 2, 1, 3, 4 because of the values like 283/ 147/ 81/ 3

Can someone help me to reach this goal?

Thanks, Armin

Re: sorting stacked bar chart with 3 dimensions

Gysbert_Wassenaar — Thu, 24 Mar 2016 15:34:44 GMT

Three dimensions? I only see two. Perhaps this discussion helps: Bar Chart 2 Dimentions sorting

Re: sorting stacked bar chart with 3 dimensions

Tue, 29 Mar 2016 05:48:44 GMT

Sorry for the confusion, for the bar chart i have combined group and the type that i can generate stacked bars. But the sorting of this combined bars should be according the 3 dimensions as explained above.

Re: sorting stacked bar chart with 3 dimensions

Gysbert_Wassenaar — Tue, 29 Mar 2016 05:58:23 GMT

Please post a small qlikview document that illustrates the problem