Script

[RealEstate2018]

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)';

[Arthur_Fong]

What is the expression in the variable?

[RealEstate2018]

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

[JGMDataAnalysis]

Something like this?

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

[Brett_Bleess]

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

[RealEstate2018]

Hi Guys,

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