Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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