topic Re: Sorting help in Stacked bar chart ! in QlikView

Sorting help in Stacked bar chart !

amit_saini — Wed, 29 Oct 2014 07:50:04 GMT

Folks,

I 'm having stacked bar char as below , having one dimension and 3 Expressions.

How can I sort like 40,26,12,10......????

Thanks,
AS

Wed, 29 Oct 2014 07:53:09 GMT

Hi,

In sort tab --> Y- axis ---> descending

it will work

alexandros17 — Wed, 29 Oct 2014 07:55:10 GMT

in sort tab uncheck all and check customized sorting, there write the sum of your expressions.

Let me know

amit_saini — Wed, 29 Oct 2014 08:01:54 GMT

Thanks Guys,

I found solution for this , need to write expression under sort tab and select descending.

Thanks for the suggestions.

Wed, 29 Oct 2014 08:12:33 GMT

Can u provide the expression what you written in sort tab.

amit_saini — Wed, 29 Oct 2014 08:42:04 GMT

Rakesh,

Here it is:

count(if(Defect_Number_Description='DC 117 - Delivery - Late shipment'and Complaint_Type='3',Complaint_Number))

Thanks,