topic Variable in Load Script in QlikView

Variable in Load Script

Lisa2 — Sat, 16 Nov 2024 01:17:12 GMT

Hello, I am trying to make a variable in the load script but there are errors so I'm not sure if it is possible. I would like to make a variable that is the sum of Items from a year range.

Load:

Items,

Sum(Items where Year 2000 >= =< 2005 from excel file) as Range,

Location,

cost,

Year

From Excel File;

Re: Variable in Load Script

Taoufiq_Zarra — Fri, 14 Feb 2020 08:09:07 GMT

you have to use a group by.
Can you share a sample data to share the exact answer?

Re: Variable in Load Script

mousumimondal — Fri, 14 Feb 2020 08:18:51 GMT

Hi Lisa,

Please create a variable (say: vRentableArea) from Setting--> Variable Overview and set default value as 0.

Then write below the script to get the sum of field values and rename as name of the variable vRentableArea.

RentableArea:

LOAD
sum([Rentable Area (SqFt)]) As vRentableArea
FROM [..\Data\Report B.xls](biff, embedded labels) WHERE [Event Year Group] = '2020';

Let vRentableArea = Peek('vRentableArea',0,'vRentableArea');

Now load the script again and you can have the vRentableArea variable with expected value at front end.

Hope this will be a helpful solution.

Thanks

Mousumi

Re: Variable in Load Script

Brett_Bleess — Wed, 11 Mar 2020 16:15:24 GMT

Lisa, did the last posters suggestion work for you? If so, do not forget to return to your thread here and use the Accept as Solution button on that post to give them credit for the help and let other Members know that it worked. If you did something different, consider posting that and once posted, use the button to mark that to close out the thread. If you are still needing something, please leave an update.

Regards,
Brett