topic Re: List Box Only Products that have Sales >0 in QlikView

List Box Only Products that have Sales >0

rustyfishbones — Wed, 04 Dec 2013 12:11:48 GMT

Hi All,

I have done this in the past, but I am missing something.

Anyone have a list box expression that only shows products that have Sales greater than 0

Regards

Alan

rustyfishbones — Wed, 04 Dec 2013 12:15:15 GMT

I have the following

=AGGR(ONLY({<Product = {"=SUM([adj-prime])>0"}>} Product), Product)

Is there a better way!

rustyfishbones — Wed, 04 Dec 2013 12:26:22 GMT

I have also tried this

Still no joy

miikkaqlick — Wed, 04 Dec 2013 12:44:42 GMT

=If(Aggr(Sum(Line),Prod)>0,Prod)

Br,

Miikka

rustyfishbones — Wed, 04 Dec 2013 12:50:11 GMT

Thanks Miika