topic Text Color in pivot table in QlikView

Text Color in pivot table

Wed, 20 Nov 2013 13:09:47 GMT

Hi All,

I have a Pivot with expression as below

Count of Status=Count(DISTINCT {<Status={'PASS'}>} RUN_ID)&' '&Count(DISTINCT {<Status={'FAIL'}>} RUN_ID)

and Dimesion as SET_ID and RUN_ID .RUN_ID s are grouped by SET_ID.

I need to give text color for expression as 'Green' to Pass count and 'Red' to Fail count.

Any idea for this?

Thanks in Advance.

Re: Text Color in pivot table

jerem1234 — Wed, 20 Nov 2013 13:47:15 GMT

It's not possible to have two different colors for one "value" of an expression (i.e. |25 10|).

Make two expressions, one for pass and one for fail:

Expression 1:

Count(DISTINCT {<Status={'PASS'}>} RUN_ID)

Expression 2:

Count(DISTINCT {<Status={'FAIL'}>} RUN_ID)

Then you can click on the "+" next to the expression, and change the "Text Color" to something like

=green()

=red()

and rgb() value.

Hope this helps!

Re: Text Color in pivot table

Wed, 20 Nov 2013 13:50:15 GMT

Hi ,

To give Text Color follow the steps,

go to Pivot Table Chart Properties > Visual Clues (Tab) > Select the expression > And then You can Set the Upper and Lower Value and Also the Color For the Text as You want.

See the attached Image.

Hope It Helps you,

Regards,

Ravikant