topic Re: Script in QlikView

Script

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

Hi all ,

This is my scenario ,i hav two calendars upload and forecast.

Each upload week has 12 forcast weeks.

each id has lock periods

in dashboad im using only Upload calendar.

If i select Upload week 1 in the calendar which has 12 forcast week ,

and it has two possible ids 1 and 2 which has different lock period.

if id 1 has selected

now i want to calculate

forecast week 1 + id l has lock period 1 = 2

so i want to display sales for the forecast week 2

I achieved it in set analysis but the dashboard loading time is high so i want to achieve it in script itself ....

PFA

Regards,

Joshua

Re: Script

sunny_talwar — Fri, 01 Apr 2016 21:13:28 GMT

There are so many objects in your attached sample and I don't even know what is required to be moved to script? Can you may be clean up the attached file and re-post?

Re: Script

ajsjoshua — Sat, 02 Apr 2016 04:46:40 GMT

Thanks for ur reply Sunny T

PFA

Regards,

Joshua.

Re: Script

sunny_talwar — Sat, 02 Apr 2016 12:10:49 GMT

Try the attached.

Note: In order to reload the application, I had to export the data from the application. So changed the calculated date column with an actual date extracted from the application. You might have to keep a note of these minor changes I had to make in order to make it work.

Script for the flag:

TEMP:

NoConcatenate

LOAD *

Resident upload;

Join (TEMP)

LOAD *

Resident Forcast;

FinalTable:

LOAD Key,

If(Week_UPs + [lock period] = Week_Fs, 1, 0) as Flag

Resident TEMP;

DROP Table TEMP;

New Expression:

=Sum({<Flag = {1}>} sales)