Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
This is my first foray into Qlikview and I've used this forum lots to help me out so thanks to the fantastic community out there!
I have a straight table which contains a field called 'Approved On:' This contains the date particular documents in sharepoint were approved.
What I am trying to do is change the colour of the cell based on the date stored in the data. So if the date in the cell is the current month of the current year then the cell background should be green but if the date is anything older than that then it should be red.
I have tried using the Visual cues but am struggling with the expression to use.
Hoping someone can guide me in the right direction.
Thanks in advance!!
Kam
Hi,
In background color of your dimension, write the following formula :
=if(InYear(YourDate,today(),'0') and InMonth(YourDate,today(),'0'),lightgreen(),lightred())