topic Re: Background color in Pivot Table in QlikView

Background color in Pivot Table

Sun, 05 Apr 2015 21:30:30 GMT

Hi all,

I use this expression : If (IsActive=1 , RGB(128,0,0) , RGB(0,128,0)) it works in straight table but not in pivot table.

By default, I want to see a red background color in the first column without any selection

How can I do that ?

Thanks for your help.

Anonymous — Mon, 06 Apr 2015 03:40:26 GMT

Hi ,

Can you share a sample qvw for better understanding

amit_saini — Mon, 06 Apr 2015 04:06:16 GMT

Hi,

In pivot table you can do this from here:

Thanks,
AS

hariprasadqv — Mon, 06 Apr 2015 04:30:40 GMT

Amit words are perfect for your scenario. visual cues will works fine for that.

Mon, 06 Apr 2015 06:58:29 GMT

See attachement.

The visual cues don't solve my problem.

Visual Cues is only for the expression not for the dimensions, isn't it ?

I want to color inactive user in the dimension.

Thanks for your help.

amit_saini — Mon, 06 Apr 2015 07:12:27 GMT

Hi,

Check if this will help u:

Thanks,

Mon, 06 Apr 2015 23:15:10 GMT

Thanks you guys!