topic Re: peek Logic in QlikView

peek Logic

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

Hi all,

i need one logic. i.e

I have project, phase and date like below

ProjectName	Phase	QAFPartsReceiptPlanDate
556	0	6/8/2016
556	116	6/8/2016
556	116	6/10/2016
556	116	6/14/2016
556	116	6/15/2016
556	116	6/30/2016
556	116	7/8/2016
556	116	7/14/2016
556	116	7/15/2016

For every project , every phase pick min and Max date and Like below

ProjectName	Phase	QAFPartsReceiptPlanDate	Output	Logic
556	0	6/8/2016	6/8/2016	min date project and Phase 0
556	116	6/8/2016	6/8/2016	min date project and Phase 116
556	116	6/10/2016	6/15/2016	above date + 7
556	116	6/14/2016	6/22/2016	above date + 7
556	116	6/15/2016	6/29/2016	above date + 7
556	116	6/30/2016	7/6/2016	above date + 7
556	116	7/8/2016	7/13/2016	above date + 7
556	116	7/14/2016	7/20/2016	above date + 7
556	116	7/15/2016	7/27/2016	above date + 7

Can any body tell me how to get this.

Note: +7 should not exceed Max date of phase and If it exceeds Pick max date instead.

Re: peek Logic

maxgro — Thu, 11 Aug 2016 18:09:36 GMT

load * inline [

ProjectName, Phase, Date

556, 0, 6/8/2016

556, 116, 6/8/2016

556, 116, 6/10/2016

556, 116, 6/14/2016

556, 116, 6/15/2016

556, 116, 6/30/2016

556, 116, 7/8/2016

556, 116, 7/14/2016

556, 116, 7/15/2016

];

t2:

load *,

if(ProjectName <> Peek('ProjectName') or Phase <> Peek('Phase'), Date, Date(Peek('Output') +7)) as Output

Resident t

order by ProjectName, Phase, Date;

DROP Table t;

Re: peek Logic

subbareddykm — Fri, 12 Aug 2016 03:15:47 GMT

Exactly same but it should not exceed my max date Check above

Example :

project=556,pHase=116 my max date is 7/15/2016 but output date 7/27/2016

If Date is exceeding output date Pick max date instead

I want to apply +7 for In between Min and Max date of of my Phase

Re: peek Logic

jonathandienst — Fri, 12 Aug 2016 05:05:45 GMT

Piggy backing on Massimo's code to get the upper range limit:

load * inline [

ProjectName, Phase, Date

556, 0, 6/8/2016

556, 116, 6/8/2016

556, 116, 6/10/2016

556, 116, 6/14/2016

556, 116, 6/15/2016

556, 116, 6/30/2016

556, 116, 7/8/2016

556, 116, 7/14/2016

556, 116, 7/15/2016

];

Join(t)

LOAD ProjectName,

Max(Date) as ProjectMaxDate

Resident t

Group By ProjectName;

t2:

LOAD *,

If(ProjectName <> Peek('ProjectName') Or Phase <> Peek('Phase'),

Date,

Date(RangeMin(Date(Peek('Output') + 7), ProjectMaxDate))

) as Output

Resident t

order by ProjectName, Phase, Date;

DROP Table t;

Re: peek Logic

subbareddykm — Fri, 12 Aug 2016 06:06:42 GMT

I have one doubt here if it exceed my max i dont want to pick max date and i want to stop there itself ,then where i need to change ?

Exp :

In output Phase=116 ,07/15/2016 that we are picking from actual date right . i want to stop 07/13/2013 .

Can tell me where i need to change from script ?