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 ,     

[sunny_talwar]

May be this

Count(DISTINCT {<loan_status = {'PAIDOFF'}, loan_ID = {"=Floor(paid_off_time) < due_date"}>} loan_ID)

[ashishpalkar]

Not worked, its giving '0' as output.

[sunny_talwar]

Are your dates and time stamps read as dual fields?

[nitin_01]

or may be this

a Flag at backend : If(paid_off_time<due_date,1,0) as Flag

and expression as : =Count(DISTINCT {<loan_status={'PAIDOFF'},Flag={1}>} loan_ID)

Regards,

Nitin G.

[sunny_talwar]

More on this here

Why don’t my dates work?

Get the Dates Right

QlikView Date fields

[nitin_01]

Hi sunny,

with due respect, I doubt in expression for the striked one would give desired result.

Count(DISTINCT {<loan_status = {'PAIDOFF'}, loan_ID = {"=Floor(paid_off_time) < due_date"}>} loan_ID)

Regards,

Nitin G.

[sunny_talwar]

Why not

[nitin_01]

because within set analysis for

loan_ID={"=Floor(paid_off_time)<due_date"}

in this loan_ID has different data type whereas paid_off_time and due date are of different type, which wont give desired result as per my understanding.

Regards,

Nitin G.

[sunny_talwar]

Have you not used Search string in set analysis? May be read it here

Re: Why i am not getting same result with Above function ?