Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
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.