topic Re: conditional color formatting in pivot table in QlikView

conditional color formatting in pivot table

rajaqliks — Mon, 04 Feb 2019 18:29:47 GMT

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:

Re: conditional color formatting in pivot table

rubenmarin — Mon, 04 Feb 2019 19:12:18 GMT

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.

Re: conditional color formatting in pivot table

rajaqliks — Mon, 04 Feb 2019 19:38:15 GMT

Thanks it working like a charm