Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
agruenwald
Contributor II
Contributor II

Filter for a chart

Hello !!

I have this small example including products and their actual stock value. As I am only interested in those products, where the sum of all stock values is lower than 0, I would like to have the rows with positive values eliminated. How can I do that ?

Thanks a lot, Sascha

1 Solution

Accepted Solutions
jerem1234
Specialist II
Specialist II

Try:

Sum({<Product = {'=sum([On Stock])<0'}>}[On Stock])

Hope this helps!

View solution in original post

3 Replies
jerem1234
Specialist II
Specialist II

Try:

Sum({<Product = {'=sum([On Stock])<0'}>}[On Stock])

Hope this helps!

View solution in original post

jerem1234
Specialist II
Specialist II

You can also use:

if(Sum([On Stock])<0, Sum([On Stock]))



agruenwald
Contributor II
Contributor II
Author

Thanks a lot, worked fine.