topic How to subtract Date in QlikView

How to subtract Date

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have a table in which i have Order Logging Date and Request Delivery Date.

I want to subtract Request Delivery Date.- Order Logging Date and add a column no_of_days.

Thanks in advance!!

Re: How to subtract Date

devarasu07 — Tue, 28 Nov 2017 06:22:35 GMT

Hi,

Try like below,

load *, Interval(Date([Requested delivery date]-[Order Logging Date]),'d') as DateDiff;

LOAD * INLINE [

Order Logging Date, Requested delivery date

02/01/2017, 05/01/2017

07/01/2017, 10/01/2017

10/01/2017, 15/01/2017

16/01/2017, 20/01/2017

17/01/2017, 20/01/2017

27/01/2017, 29/01/2017

];

Re: How to subtract Date

kaushiknsolanki — Tue, 28 Nov 2017 06:25:32 GMT

Try this.

Load *,Interval([Requested delivery date]-[Order Logging Date],'d') as No_of_Days;

LOAD Date(Date#([Order Logging Date], 'DD/MM/YYYY')) as [Order Logging Date],

Date(Date#([Requested delivery date], 'DD/MM/YYYY')) as [Requested delivery date]

FROM

File.xlsx

(ooxml, embedded labels, table is Sheet1);

Regards,

Kaushik Solanki

Re: How to subtract Date

Anonymous — Tue, 28 Nov 2017 06:34:26 GMT

Hi Devarasu,

Thanks for your reply.But i can't get the desired result.Please find attached qvw file.

Re: How to subtract Date

devarasu07 — Tue, 28 Nov 2017 06:40:46 GMT

Hi,

in your expression use 'D' instead of 'S'

=Interval(Date([Requested delivery date])-Date([Order Logging Date]),'D')

Re: How to subtract Date

Anonymous — Tue, 28 Nov 2017 06:42:45 GMT

Thanks for your reply kaushik.

I tried to get no of days in text object.

Re: How to subtract Date

kaushiknsolanki — Tue, 28 Nov 2017 07:24:06 GMT

you want for each item? or difference between minimum and maximum date?

Regards,

Kaushik Solanki