topic Re: Calculation for Past Due Days (Balance) in QlikView

Calculation for Past Due Days (Balance)

Thu, 08 Sep 2016 18:11:25 GMT

Hi every one,

How I can to calculate the Past Due Days for the Salary for example just i have the Past Due Date

Numer Provider Past Due Date Past Due Days

12345678 25/11/2015 = 25/11/2015 - today()

34567811 29/12/2015 = 29/12/2015 - today()

I mean i dont have a calendary to do this can you help

sunny_talwar — Thu, 08 Sep 2016 18:23:56 GMT

May be like this:

LOAD [Numer Provider],

[Past Due Date],

([Past Due Date] - Today()) as [Past Due Days]

FROM ....

Ricardo_Gerhard — Thu, 08 Sep 2016 18:45:03 GMT

Dear Omar,

If you want to know how much days left from today, uses the sintax:

Today()-[Past Due Date] as "DaysFrom"

Anyway, you can use other functions like null, date format.

Please, mark the CORRECT/HELPFULL comment to help us.

Regards,