Scripting

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

Hi Guys,

Currently I have a variable formula =num($(eRSFPerTotalAttorneys), '#,##0') that says....

give me the size of all locations and divide it by the number of all attorneys for all locations. Here is the set analysis I have set for this Variable...

SET eRSFPerTotalAttorneys = $(eRSF) / $(eTotalAttorneys);

SET eRSF = 'sum(Size)';

SET eTotalAttorneys = 'sum([Total Number of Attorneys])';

Can someone please help me modify the Set analysis to exclude Beijing and Shanghai locations?

I tried this but it comes up as blank ...

SET eRSFPerTotalAttorneyss = $(eRSFF) / $(eTotalAttorneyss);

SET eRSFF = 'sum({<City-={'Beijing', 'Shanghai', 'Taipei'}>}(Size)'; //without Asia

SET eTotalAttorneyss = 'sum({<City-={'Beijing', 'Shanghai', 'Taipei'}>} [Total Number of Attorneys]) '; //without Asia

When I don't try to exclude anything, it populates as 6408, but when I try to exclude these locations, it comes up blank

Re: Scripting

asinha1991 — Mon, 07 Oct 2019 19:42:10 GMT

I see a possible issue

SET eRSFF = sum({<City-={'Beijing', 'Shanghai', 'Taipei'}>}Size);

and it will be better if you don't use quotes outside or use double quotes (should work with set if I am not wrong)

topic Scripting in QlikView

Scripting

Re: Scripting