Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

cancel
Showing results for 
Search instead for 
Did you mean: 
ashishpalkar
Creator III
Creator III

Count dates less than due dates.

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 ,     

14 Replies
nitin_01
Creator
Creator

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
Creator
Creator

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.