topic Re: Need help in QlikView

Need help

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

Hi Team,

I have data like below:

In below data END column have 31/01/2019 two times and START column have two different dates(01/01/2018,05/03/2018)

Hear 05/03/2018 date is part of (01/01/2018 to 31/01/2019).So I want to include 05/03/2018 into 01/01/2018.

if I select 01/01/2018 in filter, Need to display 01/01/2018 data and 05/03/2018 data in straight table.

START	END
01/01/2017	31/12/2017
05/11/2017	30/06/2018
01/01/2018	31/01/2019
05/03/2018	31/01/2019

Results:

START	END
01/01/2017	31/12/2017
05/11/2017	30/06/2018
01/01/2018	31/01/2019

Re: Need help

felipedl — Fri, 06 Apr 2018 13:40:24 GMT

Hi gireesh,

The following code will do the trick:

Load * Inline

[

START,END

01/01/2017,31/12/2017

05/11/2017,30/06/2018

01/01/2018,31/01/2019

05/03/2018,31/01/2019

];

NoConcatenate

Load

START,

END

where [Remove Date]=0;

Load

START,

END,

// search for a same end date and marks it to be removed after

if(END = peek(END),1,0) as [Remove Date];

Load

START,

END

Resident x

order by START;

drop table x;

Re: Need help

gireesh1216 — Fri, 06 Apr 2018 15:09:05 GMT

Its working fine .But data is missing in this logic

can u please check this

Load * Inline

[

START,END,A

01/01/2017,31/12/2017,1

05/11/2017,30/06/2018,2

01/01/2018,31/01/2019,3

05/03/2018,31/01/2019,4

];

NoConcatenate

Load

START,

END,

where [Remove Date]=0;

Load

START,

END,

// search for a same end date and marks it to be removed after

if(END = peek(END),1,0) as [Remove Date];

Load

START,

END,

Resident x

order by START;

drop table x;

results:

expected results:( i want out put like below)

Re: Need help

felipedl — Fri, 06 Apr 2018 16:36:19 GMT

You can just add the needed lines to a new Qlikview application and test it, just paste the code you have in there.

Felipe.

Re: Need help

boorgura — Fri, 06 Apr 2018 17:29:08 GMT

Just a minor change to this should get the desired output:

Load * Inline

[

START,END

01/01/2017,31/12/2017

05/11/2017,30/06/2018

01/01/2018,31/01/2019

05/03/2018,31/01/2019

];

NoConcatenate

Load

END,

// search for a same end date and marks it to be removed after

if(END = peek(END),peek(START),START) as START;

Load

START,

END

Resident x

order by START;

drop table x;

Re: Need help

felipedl — Fri, 06 Apr 2018 17:51:18 GMT

You're right Rakesh,

I forgot to order the dates, since they were ordered on the inline load it worked.

Thanks .

Re: Need help

gireesh1216 — Mon, 09 Apr 2018 04:47:43 GMT

Thanks Felip

Its working fine

Re: Need help

gireesh1216 — Mon, 09 Apr 2018 04:48:07 GMT

Thanks Rakesh...