topic Re: Text in Chart - setting colours in QlikView

Text in Chart - setting colours

Thu, 07 Aug 2014 03:15:36 GMT

Hello,

I am trying to set the colour of text in a pie chart based on a condition.

I want the text 'Sales' to appear in green if > 10000, orange if between 8000 - 10000, and red if < 8000.

I tried some versions of the following, but get errors in expression:

=if(sum([SALES VOLUME]) > 10000,

RGB(0,255,64) 'Sales & Referrals'))

Any help appreciated.

Thanks

Wayne

JonnyPoole — Thu, 07 Aug 2014 03:26:50 GMT

Which text exactly in the pie chart ? Here i enabled 'values on data points' and added a conditional color for sales < 10000.

Text Color under the expression is: if(sum(Sales)<10000,lightred(),green())

Thu, 07 Aug 2014 03:34:27 GMT

Thanks for the reply Jonathan,

It is for text added under 'Text in Chart' in the Presentation tab - using the edit expression in the text field.

Not sure if it can be done there?

Wayne

JonnyPoole — Thu, 07 Aug 2014 03:39:19 GMT

that should work too. I put the exact same expression under the font properties (change color to 'caluclated').

Here you can see the text changing color depending on the sum(Sales) in the current selection.

JonnyPoole — Thu, 07 Aug 2014 03:44:26 GMT

noticed a type in your expression. so instead of this;

=if(sum([SALES VOLUME]) > 10000,

RGB(0,255,64) 'Sales & Referrals'))

try this:

=if(sum([SALES VOLUME]) > 10000, green(), if( sum([SALES VOLUME]) > 8000,rgb(255,128,64), red()))

israrkhan — Thu, 07 Aug 2014 03:50:06 GMT

Yes , you can do it,,,,

see the steps in image, i just made 1 image of 5 steps, follow the steps in the image...

Hope it Helps....

Edit:

You already done it....Great

Thu, 07 Aug 2014 03:54:58 GMT

Thank you Jonathan & Isar,

Very helpful, and I can apply the same methodology to the background if I choose.

Thanks heaps.