topic Re: Additional Sorting within Bar Chart in QlikView

Additional Sorting within Bar Chart

Sun, 21 Oct 2012 15:23:46 GMT

Hi, I have been trying to get this chart arranged in a certain way - got so far and then I'm stuck!

Any help is appreciated.

I have used the following sort calculation to organise the data in the chart below:

This organises the workmodes into the order required

=Only({1} Match(response_level1,'Focus','Collaborate','Network','Develop'))

I would like to sort the Activities within each Workmode in descending order!

Thanks

Rob

swuehl — Sun, 21 Oct 2012 17:15:53 GMT

Try something like

= -Match(response_level1,'Focus','Collaborate','Network','Develop') *FieldValueCount('ChartDimension') +rank(sum(Value))

where ChartDimension is the field name you use as dimension in your chart and sum(Value) is the expression you are using.

Sun, 21 Oct 2012 18:39:47 GMT

Hi swuehl, that's the answer! - I had to reverse the order of the response level to get the chart to work in the right order.

= -Match(response_level1,'Develop','Network','Collaborate','Focus') *FieldValueCount('percentsplit') +rank(sum(percentsplit))

Just setting the colours to match and it's done.

Thanks

Rob

swuehl — Sun, 21 Oct 2012 18:57:12 GMT

Ah, yes, I think removing the first minus sign should also correct for the right sorting:

= Match(response_level1,'Focus','Collaborate','Network','Develop')*FieldValueCount('ChartDimension') +rank(sum(Value))

Regards,

Stefan

Sun, 21 Oct 2012 19:38:56 GMT

Yes that did it, good to know.

Thanks

Rob