Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I'm really new to Qlikview (only been using it a couple of weeks so far) and was wondering if anyone could help with this issue.
I have two dates that I want to compare (two columns): [COMPLETED DATE] & DEADLINE.
I basically want to know how I would count the amount of times [COMPLETED DATE] was greater than DEADLINE?
Should I use an if statement?
Any ideas would be great.
Thanks,
Todd
An if should do the trick.
sum(if([COMPLETED DATE] > DEADLINE,1)
-Rob