topic Re: SET ANALYSIS in QlikView

SET ANALYSIS

MK_QSL — Fri, 27 Sep 2013 11:39:13 GMT

I want to count different part number having quantities greater than 0.

How to write in set analysis?

COUNT({Quantity > 0}Distinct [Part Number])

swuehl — Fri, 27 Sep 2013 11:42:10 GMT

COUNT({<Quantity = {">0"} >} Distinct [Part Number])

Anonymous — Fri, 27 Sep 2013 11:48:34 GMT

Manish

Try: COUNT ( { < Quantity = ">0" > ) Distinct [Part Number])

Best Regards, Bill

rustyfishbones — Fri, 27 Sep 2013 11:50:08 GMT

Hi Swuehl,

How would it look if you wanted the SUM(Quantity)

would it be

COUNT({<SUM(Quantity) = {">0"}>} DISTINCT [Part Number])

or is it different?

swuehl — Fri, 27 Sep 2013 12:00:34 GMT

You can use only pure field names on the left side of field modifiers.

You can try something like

count( {< [Part Number] = {"=sum(Quantity)>0"} >} DISTINCT [Part Number])

Fri, 27 Sep 2013 12:04:35 GMT

sth like with p() function

count({<[part Number] = p({1}<[part Number]) >} distinct [part Number])

count( {<[part Number] = {"=sum(Quantity)>0" } distinct [part Number]) )

Fabrice

rustyfishbones — Fri, 27 Sep 2013 13:33:58 GMT

thanks

rustyfishbones — Fri, 27 Sep 2013 13:52:56 GMT

I have a list box with 7000+ product codes

How do I only show the 900 codes that have sales,

swuehl — Fri, 27 Sep 2013 13:57:51 GMT

You can use the search bar on top of the list box

=sum(Sales)>0

or if you want to create a filtered list box, use a field expression:

=aggr( if(sum(Sales)>0,ProductCode), ProductCode)

=aggr(only({<ProductCode = {"=sum(Sales)>0"}>} ProductCode), ProductCode)

rustyfishbones — Fri, 27 Sep 2013 16:01:20 GMT

excellent thanks