Discussion board where members can get started with Qlik Sense.
Can any one please help me to create the below flag.
When Date 1 is greater than or equal to Date 2 then it has to show 1 else 0. But when Date 1 and Date 2 both are same getting 0 instead of 1. Please help me on this.
Please find the below attached app.
Thanks in advance.
Go to Solution.
@mahitham Hi, try this
It's probably because of your date format, if you convert in into a floored numeric value it should work.
Vlad is correct. Your date part of the two dates are the same, but your timestamp of Date2 is bigger. I checked and if(Floor(Date1)>=Floor(Date2),1,0) also works without converting to a number.
can you try something like