Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
kam_patel61
New Contributor

Change Cell colour based on Date in Cell

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

1 Reply
sergio0592
Valued Contributor II

Re: Change Cell colour based on Date in Cell

Hi,

In background color of your dimension, write the following formula :

=if(InYear(YourDate,today(),'0') and InMonth(YourDate,today(),'0'),lightgreen(),lightred())

Community Browser