topic Re: Sorting in stacked Bar chart in QlikView

Sorting in stacked Bar chart

Anonymous — Tue, 01 Aug 2017 04:22:08 GMT

Hi All,

I am using a Stacked bar chart with one dimension and I want to sort based on the each expression values and all %s to be shown in descending order in all five bars in QV.

Thanks in advance

Re: Sorting in stacked Bar chart

md_qlikview — Tue, 01 Aug 2017 04:38:40 GMT

Hi,

How many expressions you are using in the chart? Can you post your sample file for better understanding ?

Thanks

Re: Sorting in stacked Bar chart

Siva_Sankar — Tue, 01 Aug 2017 05:20:26 GMT

Hi Kavyashree,

Not sure about your expression. In your sort tab in the chart properties, you can create expression to sort.

stacked bar chart sort order

-Siva

Re: Sorting in stacked Bar chart

Anonymous — Tue, 01 Aug 2017 06:41:01 GMT

Please find the attached example.And I want to sort based on the each expression values in each bar.

Re: Sorting in stacked Bar chart

md_qlikview — Tue, 01 Aug 2017 07:07:46 GMT

Hi Kavyashree,

PFA file which may solve your sorting problem

Re: Sorting in stacked Bar chart

Anonymous — Tue, 01 Aug 2017 08:26:48 GMT

Thanks for your response.I want to sort descending order based on values of each segment.The numbers to be shown in descending order in all four bars in QV.

(for fourth bar first ccc=2222 (green),second aaaa=898(blue) then bbb=477 (red) should display ).

Re: Sorting in stacked Bar chart

Siva_Sankar — Tue, 01 Aug 2017 08:37:00 GMT

Hi Kavyashree,

Not sure it is possible, see the response from experts below on similar situation earlier.

Re: Sorting in stacked Bar chart

Siva_Sankar — Tue, 01 Aug 2017 08:38:41 GMT

Correct sorting in a Bar Chart