topic Re: if there is more than 1 day difference between start date and end date then need those detail as my output in QlikView

if there is more than 1 day difference between start date and end date then need those detail as my output

Srinivas — Thu, 02 Jun 2016 11:15:59 GMT

Hi friends,

I have a requirement, that have some start date and end date 2 columns.

see the attached excel for reference...

if there is more than 1 day difference between start date and end date i need those dates in details as my output.

Thanks in Advance

Munna

Re: if there is more than 1 day difference between start date and end date then need those detail as my output

Kushal_Chawda — Thu, 02 Jun 2016 11:20:28 GMT

Create straight table

Dimension:

StartDate

EndDate

Expression:

Count({<User={"=floor(EndDate)-floor(StartDate)>1"}>}User)

Re: if there is more than 1 day difference between start date and end date then need those detail as my output

avinashelite — Thu, 02 Jun 2016 11:25:48 GMT

Try like this

LOAD StartDate,

EndDate,

ID,

User,

EndDate- StartDate as Flag

from

table;

Noconcatenate

LOAD StartDate,

EndDate,

ID,

User

from

table

where Flag>1;

Drop table T;

Re: if there is more than 1 day difference between start date and end date then need those detail as my output

Srinivas — Thu, 02 Jun 2016 11:36:26 GMT

Hi,

sorry a bit confusion in typing,

if there is more than 1 date difference then i need those dates to be aloberated...see the excel

suppose start date is 1/1/2010 and end is 1/5/2010

the

i need 5 different dates like

1/1/2010 to 1/2/2010

1/2/2010 to 1/3/2010

1/3/2010 to 1/4/2010

1/4/2010 to 1/5/2010

Thanks,

Munna

Re: if there is more than 1 day difference between start date and end date then need those detail as my output

avinashelite — Thu, 02 Jun 2016 11:50:02 GMT

you need to recreate the dates?? if that is the case use the master calendar and link you date

Creating A Master Calendar

Re: if there is more than 1 day difference between start date and end date then need those detail as my output

help4qv123 — Thu, 02 Jun 2016 12:01:32 GMT

How we can link...if we link it dates we can link min date to startdate and max date to end date...

but how can we get this type of output..can u help out if u got any idea