topic Re: Filter for a chart in QlikView

Filter for a chart

Anonymous — Tue, 25 Nov 2014 14:45:37 GMT

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

Re: Filter for a chart

jerem1234 — Tue, 25 Nov 2014 14:51:26 GMT

Try:

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

Hope this helps!

Re: Filter for a chart

jerem1234 — Tue, 25 Nov 2014 14:53:32 GMT

You can also use:

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

Re: Filter for a chart

Anonymous — Tue, 25 Nov 2014 14:57:16 GMT

Thanks a lot, worked fine.