topic Re: How do I add conditional colours to the dimension values in pivot chart? in QlikView

How do I add conditional colours to the dimension values in pivot chart?

nikita42 — Mon, 22 Feb 2016 14:14:05 GMT

I have a table comparing current location to target location. I want to colour the cells where the current <> target in red. How do I do this?

Function	Current Location	Target
A	London	London
B	Bangalore	Mumbai
C	Glasgow	London
D	Bangalore	Bangalore

In this table, I would want to colour rows B and C in red.

Re: How do I add conditional colours to the dimension values in pivot chart?

sunny_talwar — Mon, 22 Feb 2016 14:19:51 GMT

May be something like this for background color:

=If([Current Location] <> Target, Red(), Green())

Re: How do I add conditional colours to the dimension values in pivot chart?

nikita42 — Mon, 22 Feb 2016 15:00:34 GMT

I tried that, but it doesn't work on a table.

Re: How do I add conditional colours to the dimension values in pivot chart?

sunny_talwar — Mon, 22 Feb 2016 15:15:50 GMT

Would you be able to provide a sample?

Re: How do I add conditional colours to the dimension values in pivot chart?

richard — Mon, 22 Feb 2016 15:33:46 GMT

Have you tried this on the expressions?

Re: How do I add conditional colours to the dimension values in pivot chart?

pooja_sn — Mon, 22 Feb 2016 15:37:40 GMT

=if(not match([Current Location],[Target]),Red(),Green())

Re: How do I add conditional colours to the dimension values in pivot chart?

nikita42 — Mon, 22 Feb 2016 15:52:19 GMT

I've attached a sample table. I need to colour all rows where the location category <> Target.

Thanks!

Re: How do I add conditional colours to the dimension values in pivot chart?

Peter_Cammaert — Mon, 22 Feb 2016 15:56:54 GMT

Yes, it does. We have no idea what table you are referring to, and it works on all of mine. See attachment.

Follow Sunny's suggestion if you want a solution that works for you as well.

Best,

Peter

Re: How do I add conditional colours to the dimension values in pivot chart?

nikita42 — Mon, 22 Feb 2016 16:11:04 GMT

For some reason, this just isn't working on my actual table. Could there be some options in the presentation or style tabs that need to be checked/unchecked?

Re: How do I add conditional colours to the dimension values in pivot chart?

nagarjuna_kotha — Mon, 22 Feb 2016 16:39:35 GMT

Like this?

Re: How do I add conditional colours to the dimension values in pivot chart?

sunny_talwar — Mon, 22 Feb 2016 16:59:41 GMT

Please find attached

Re: How do I add conditional colours to the dimension values in pivot chart?

Peter_Cammaert — Mon, 22 Feb 2016 17:17:14 GMT

Yes, it does work allright.

In your sample document, add this expression to all Background Color properties in each dimension (on tab Dimensions, expand the tree under each dimension name, select Background Color and click Edit...) and to the Background Color property of the expression (on tab Expression, expand the tree, select Background Color property and put the following in the Definition field).

=IF ([Location Category] <> Target, RGB(255, 204, 204))

It works without any other toggles, checks or properties that must be changed.

Good luck,

Peter

PS the color is not as bright as the one Sunny uses, because that type of red may hide the cell content. YMMV, you should experiment with different values to find a pleasing color.

Re: How do I add conditional colours to the dimension values in pivot chart?

nikita42 — Mon, 22 Feb 2016 17:34:52 GMT

Got it! My cell background transparancy was set to 100%. That's why the colors didn't show up!

Thanks so much