1 Reply Latest reply: Jun 5, 2017 6:49 AM by Jean-Baptiste RENAULT RSS

    Change Cell colour based on Date in Cell

    Kam Patel

      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