How to get days in due in table box? - Page 2 - Qlik Community

Report Inappropriate Content · ‎2014-07-04

Hi,

I have table box with data. How can I calculate the Days in Due. I have to use the below formula in table box. can anyone suggest me please.

Days in due = =Days360(Today(), RecentDate)

Thanks.

Report Inappropriate Content · ‎2014-07-07

Thanks. When I used this there is some data is missing. How can I get all data. Please help.

Anonymous · ‎2014-07-07

Hi Amelia,

When you are saying data missing, are you referring to other months data in RecentDate field. You will get only 4 months data by applying this logic, not all months data.

You may create new field "RecentDate as RecentDateOriginal" to verify the logic.

Thanks