Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Count the amount times one date is greater than another date

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

1 Reply
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

An if should do the trick.

sum(if([COMPLETED DATE]  > DEADLINE,1)

-Rob