topic Sort Legend in Pie Chart (Sort everything ascending by value except one entry) in QlikView

Sort Legend in Pie Chart (Sort everything ascending by value except one entry)

Mon, 07 Nov 2011 20:22:32 GMT

Dear all,

I'm looking for a solution in sorting the entries in a pie chart.

I want to sort all entries by the amount of Revenue.

Product S 1.000,-

Product A 899,-

Product K 780,-

Product X 400,-

I want the Product A to be the last:

Product S 1.000,-

Product K 780,-

Product X 400,-

Product A 899,-

Thanks for your help guys,

Daniel Philips

Mon, 07 Nov 2011 20:35:47 GMT

Hi Daniel

Just sort the pie with expression

=sum( if( Product ='Product A' , 0, revenue) )

Mon, 07 Nov 2011 20:44:29 GMT

Thanks JJ. 🙂

Talk to myself: first think, then post