Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
rajaqliks
New Contributor III

conditional color formatting in pivot table

Hi Folks,

I need to greayed out particular column in pivot table please help i am adding the sample qvw 

condition: if(WEEKEND='11/23/2018',rgb(225,225,225)

Result:

grey.PNG

1 Solution

Accepted Solutions

Re: conditional color formatting in pivot table

Hi, you can try with:
If(Floor(WEEKEND)=Date('11/23/2018'), RGB(128,128,128))
// Used floor() to remove decimals, weekend is at 23:59:59

But cells without data will remain white until there is some data that relates rows and columns.
2 Replies

Re: conditional color formatting in pivot table

Hi, you can try with:
If(Floor(WEEKEND)=Date('11/23/2018'), RGB(128,128,128))
// Used floor() to remove decimals, weekend is at 23:59:59

But cells without data will remain white until there is some data that relates rows and columns.
rajaqliks
New Contributor III

Re: conditional color formatting in pivot table

Thanks it working like a charm