How to calculate days in due?

[#1]

Hi,

I have tablebox with columns from the same table. There is one column DueDate with dates from 2009. How to write script to calculate 'days in due'. I know to calculate in excel with below formula

=DAYS360(Today(),DueDate)

I am trying to wrire in QLikview script. Please can anyone suggest me how to do this.

Thanks.

[sibideepak]

Hi  Amelia2000,

Store DueDate as variable

and Make expression like this

=today()-vduedate

it will return number of days

Thanks

Deepak

[#3]

Thanks. how can I change if it required duedate values to show with three months

for eg: July 2014, August 2014, sept 2014

so, it should populate for every three months.

Please help.

[MarcoWedel]

Can specify with some more examples?

[#5]

So you want those three months to be dynamically changing?

[#6]

Yes you are right

[sudeepkm]

if you have Due dates per record in your table then you can write a script like below

Today() - DueDate as DueinDays // for future dates the value will be in negative and you can use a flag too.

[sibideepak]

Hi

I couldn't able to catch up with your concept .

Can you little more explain it ??

Thanks ,

Deepak

[#9]

Sorry if not clear.  I have to send a table data to user daily. This table is from access and all the columns are from only one table. days in due is one column which I have been using a formula in excel

=DAYS360(TODAY(),DueDate)

This DueDate should have dates changes dynamically every day. but the date range should be

for eg: now we are in August. so the DueDate dates will be from July 2014 to 31 August 2014. I need this values should change dynamically. so, the days in due will get automatic values.

now I decided to build a Qlikview report to generate this automatically.

is it possible with variable? Please suggest

[sibideepak]

One thing needed to be clear !!

how you are getting this due dates ??

how your calculating due dates(logic) in your business ??