Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Thanks Kaushik,
that worked 🙂
I marked it as a solution!
Greets,
Yannik
Good to know that.
Cheers,
Kaushik Solanki