Indicator if a date is exceeds a certain date

[YannikPrill]

Hey QLIK Brains,

I have a table that dispalys two dates. Lets say the inputs are [A] for date A and [B] for date B. I now need a third column that indicates if date B exceeds date A. Maybe the field could turn red or sth. 

Also I need to count how many times date B exceeded date A. Maybe that number could be displayed as a KPI or sth. like that. 

Thx in advance for your help 🙂 

Greets,

Yannik

[kaushiknsolanki · Accepted solution]

Hi,

You can just add one if statement with condition and create a new flag  for example.

Load * , If(DateB > DateA,1,0) as DateBExceedFlag

From xyz;

Now you can just Sum DateBExceedFlag to find the total such dates.

Regards,

Kaushik Solanki

[YannikPrill]

Thanks Kaushik,

that worked 🙂 

I marked it as a solution!

Greets,

Yannik

[kaushiknsolanki]

Good to know that.

Cheers,

Kaushik Solanki