filter product codes with 0 sales

[robmarr789]

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

[rwunderlich · Accepted solution]

I  would think the set would be:

{<[product code]={"=sum(sales)=0 and sum(SOH)>0"}>}

See attached

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

http://www.easyqlik.com

[robmarr789]

Sorry can't see attachment?

[trdandamudi]

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)

[trdandamudi]

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.