2 Replies Latest reply: May 22, 2017 5:53 PM by Basel Elias RSS

    Data Validation - if a date is entered that is in the future, how do i call it out in a pivot?

    Basel Elias

      Hello,

       

      I hope this finds you all well.

      New to Qlik

       

      Example:

       

      2017-APR - 10 items sold

      2017 MAY- 15 items sold

      2017 JULY - 1 item sold

       

       

      In Qlik, is there a way to call it out, I was planning on doing a dash board to just catch bad data entering our system.

      Basically in the pivot, the July date would be red.

       

      The items are done by a count and the date of items sold is "Entry"

      This is basically conditional formatting in Excel, but I want it to know how to do it in Qlik and have it display in red if possible?

       

      Thank you