topic Re: latest 5 week in script in QlikView

latest 5 week in script

Wed, 07 Jan 2015 05:16:39 GMT

Dear All,

i need to calculates incremental for latest 5 week in script..

please reply soon

LOAD

Distinct

Week

From ABC where ?;

Present data is Week :201434,201435,201436,201437,201438,201439

Required data is Week : 201438,201439 only

Re: latest 5 week in script

tresB — Wed, 07 Jan 2015 05:55:39 GMT

Try like:

Temp:

Load

Max(Week, 5) as LFifthWeek

From <>;

Let vWeek=Peek('LFifthWeek');

Drop Table Temp;

Final:

Load

...

Week

From <> Where Week >=$(vWeek);

Re: latest 5 week in script

Wed, 07 Jan 2015 06:00:35 GMT

Try this

Load Max(WeekNum) as Max;

Load *,Right(Week,2) as WeekNum Inline [

Week

201434

201435

201436

201437

201438

201439

];

Let vMax = Peek('Max',-1,A);

Load * Inline [

Week

201434

201435

201436

201437

201438

201439

]

Where Right(Week,2)>=($(vMax)-1) and Right(Week,2)<=$(vMax);

Hope it helps you..

Re: latest 5 week in script

priyalshah9779 — Wed, 07 Jan 2015 06:04:26 GMT

Hi Rahul

I have tried to make the solution , Let me know this is hat you are looking for

Thanks

Priyal