topic Re: Script in QlikView

Script

RealEstate2018 — Sat, 16 Nov 2024 02:13:15 GMT

Hi Guys,

Can someone help me modify my script so that the system doesn't pick up negatives in this chart?

I don't want to exclude Phoenix by "City" as there is another Phoenix location with positive sqft. I want to exclude all negative sqft. Possibly within the =$(eRSF) script.

SET eRSF = 'sum(Size)';

Re: Script

Arthur_Fong — Tue, 15 Oct 2019 23:40:47 GMT

What is the expression in the variable?

Re: Script

RealEstate2018 — Wed, 16 Oct 2019 20:55:42 GMT

Here is the Variable expression SET eRSF = 'sum(Size)';

Re: Script

JGMDataAnalysis — Wed, 16 Oct 2019 22:07:12 GMT

Something like this?

SET eRSF = Sum({<City={"=Sum(Size)>=0"}>} Size);

Re: Script

Brett_Bleess — Tue, 22 Oct 2019 14:49:44 GMT

Alen, did Javier's post get you what you needed? If so, do not forget to come back to your thread and use the Accept as Solution button on his post to give him credit for the help as well as let others know that worked. If you are still working on things, please provide an update.

You can also use the following link to search for examples within the Design Blog area of the Community, there are hundreds of posts in this area that are mostly how-to etc., which may be very helpful to you:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett

Re: Script

RealEstate2018 — Tue, 22 Oct 2019 19:52:47 GMT

Hi Guys,

Thanks for the reply but this did not change anything. I am still searching for a solution.