Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ,
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.
Super
Correction?
Floor() not working within search. I tested removing Floor function and it worked.
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.