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

[Anonymous]

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

[sunny_talwar · Accepted solution]

May be like an if statement to highlight the future dates

If(DateField > Today(), Red())

[Anonymous]

Thank you very much! That was very helpful!