Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I'm fairly new to qlikview.
I wan't to filter my chart called "sales" so that it returns the view you see in the "output" chart.
Essentially I'm looking to list all items that have 0 sales put have SOH.
If someone could demonstrate in my file and reattach that would be great.
Thanks
I would think the set would be:
{<[product code]={"=sum(sales)=0 and sum(SOH)>0"}>}
See attached
-Rob
I would think the set would be:
{<[product code]={"=sum(sales)=0 and sum(SOH)>0"}>}
See attached
-Rob
Sorry can't see attachment?
One more way you can do is as below:
Replace your expressions with below
=Sum({<[product code]={"=Len(Trim(sales))=0"}>} sales)
=sum({<[product code]={"=Len(Trim(sales))=0"}>} SOH)
When you open the thread from Inbox, you will not see the attachment. Open the thread from outside the Inbox and you can see it.