topic Need help to add numeric value with date field in QlikView

Need help to add numeric value with date field

Thu, 03 Nov 2011 07:17:59 GMT

Good Morning All,

When I try to add 30 days with a date filed the output is wrong, I tried like this =Invoice date +30 it shows incorrect value.

How to do this..Can you help me..

Chriss

kaushiknsolanki — Thu, 03 Nov 2011 07:22:39 GMT

Hi,

First thing make sure that the field contains valid date.

Second if you want to change the month (30/31 days) you can use the addmonth() function to achieve it.

For more on addmonth() look for Qlikview Help.

If not then please send us the sample qvw file.

Regards,

Kaushik Solanki

Thu, 03 Nov 2011 07:23:24 GMT

try this ..........

=date(Date + 30)

Thu, 03 Nov 2011 07:54:13 GMT

Hello Kaushik,

Thanks for your reply, In the script itself I would like to add 30 days with the Invoice date for calculation.

is it possible..

LOAD [Invoice Number],

[Invoice Date],

[Invoice Date] as duedate +30

FROM

(biff, embedded labels, table is Sheet1$);

Regards

Chriss

Thu, 03 Nov 2011 08:53:55 GMT

Date( [Invoice Date] + 30) as Duedate

Thu, 03 Nov 2011 09:17:35 GMT

Dear Chriss,

if u want to add 30 days in invoice date to make it due date u should write the script like this

Load [Invoice Number],

[Invoice Date],

date([Invoice Date]+30) as DueDate

FROM

(biff, embedded labels, table is Sheet1$);

Thu, 03 Nov 2011 09:43:05 GMT

Dear Gunjita,

Thanks for your help, it works

Chriss