topic sort a chart in QlikView

sort a chart

Wed, 28 Nov 2012 18:04:06 GMT

How can i sort this chart?

from full blue to minimum blue color. that means highest yes percentage to lowest

Re: sort a chart

MayilVahanan — Wed, 28 Nov 2012 18:24:51 GMT

Sort tab, use expression

and give descending order.

in expression tab, give the expression first expression..

ex:

1.sum(sales) display as blue color

2.sum(discount) display as red color..

Give sum(sales) in expression in sort tab..

Hope it helps

pls share sample file..

Re: sort a chart

Thu, 29 Nov 2012 04:33:22 GMT

I tried this but it didnt work. Please note we have 2 dimensions, "Locations" and "Recommend hospital" so in the sort we select the dimension and check the sorting technique we want.

Any other ideas???

Re: sort a chart

Tue, 12 Mar 2013 02:07:38 GMT

IN expression under sort tab, try using COUNT({<Recommend Hospital={'Yes'} >} Recommend Hospital) and descending order