Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
sindus123
New Contributor III

Sorting in stacked Bar chart

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

@sort.png

7 Replies
md_qlikview
Contributor II

Re: Sorting in stacked Bar chart

Hi,

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

Thanks

Siva_Sankar
Honored Contributor

Re: Sorting in stacked Bar chart

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

sindus123
New Contributor III

Re: Sorting in stacked Bar chart

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

md_qlikview
Contributor II

Re: Sorting in stacked Bar chart

Hi Kavyashree,

PFA file which may solve your sorting problem

sindus123
New Contributor III

Re: Sorting in stacked Bar chart

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 ).


Siva_Sankar
Honored Contributor

Re: Sorting in stacked Bar chart

Hi Kavyashree,

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

Capture.JPG

Siva_Sankar
Honored Contributor

Re: Sorting in stacked Bar chart