Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

belias1980
New Contributor II

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

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

1 Solution

Accepted Solutions
MVP
MVP

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

May be like an if statement to highlight the future dates

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

2 Replies
MVP
MVP

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

May be like an if statement to highlight the future dates

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

belias1980
New Contributor II

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

Thank you very much! That was very helpful!