Count dates less than due dates.

[ashishpalkar]

Hi There

How to count dates from given list.    

From the attached sheet , I am looking for following solution.

HOW MANY CUSTOMERS HAVE PAID OF THEIR LOAN EARLIER THAN EXPECTED

Thanks ,     

[nitin_01 · Accepted solution]

Something new i learnt,  Thanks sunny .

Correction in expression : Count(DISTINCT {<loan_status = {'PAIDOFF'}, loan_ID = {"=paid_off_time < due_date"}>} loan_ID)

And it Works.

[sunny_talwar]

Super

[sunny_talwar]

Correction?

[nitin_01]

Floor() not working within search. I tested removing Floor function and it worked.

[sunny_talwar]

Problem is not Floor(), problem is that the dates and timestamps doesn't have a unique format and are most likely not read as date by qlikview . Floor will work if the field is a dual field.