Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
New Contributor II

Script

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.

 

clipboard_image_0.png

clipboard_image_1.png

clipboard_image_2.png

SET eRSF = 'sum(Size)';

Labels (2)
5 Replies
Highlighted
Partner
Partner

Re: Script

What is the expression in the variable?

Highlighted
New Contributor II

Re: Script

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

Highlighted
Contributor II

Re: Script

Something like this?

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

 

Highlighted
Digital Support
Digital Support

Re: Script

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
Highlighted
New Contributor II

Re: Script

Hi Guys,

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