topic Re: Calculate the break between to dates in QlikView

Calculate the break between to dates

Tue, 11 Sep 2012 06:51:43 GMT

Hello Community,

i attached a qv-file, that shows my problem. I want to calculate the break between two dates (end and start date).

Best regards,

Aylin

whiteline — Tue, 11 Sep 2012 07:34:50 GMT

Hi,

You can just subtract them.

=End-Start

Tue, 11 Sep 2012 09:14:40 GMT

I have to use the peek funtion and then i can subtract the right values. like

Load

Product,
date(Start) as Start
date(End) as End

if([Start]>peek('End'),[Start]-peek('End')) as break

Resident abc

order by Product,Start ;