topic Re: filter product codes with 0 sales in QlikView

filter product codes with 0 sales

robmarr789 — Wed, 25 Nov 2020 16:16:04 GMT

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 — Wed, 15 Aug 2018 15:27:41 GMT

I would think the set would be:

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

See attached

-Rob

robmarr789 — Wed, 15 Aug 2018 15:36:01 GMT

Sorry can't see attachment?

trdandamudi — Wed, 15 Aug 2018 15:36:40 GMT

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 — Wed, 15 Aug 2018 15:41:17 GMT

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.