topic Re: Limit Product Table by Sales in QlikView

Limit Product Table by Sales

rustyfishbones — Tue, 27 Aug 2013 21:17:58 GMT

Hi All,

I have a product table with 20000+ product codes.

Only 2000 of which have had sales in the last 2 years

How do I reduce the table down to only Product Codes that have Sales >0

Thanks

Alan

Re: Limit Product Table by Sales

Gysbert_Wassenaar — Wed, 28 Aug 2013 06:50:34 GMT

Create a straight table with Product Code as dimension and as expression for example sum({<Sales={'>0'}>}Sales). The part that limits the records to only those with positive sales is {<Sales={'>0'}>}. Put that in the aggregation functions in your expressions.

Re: Limit Product Table by Sales

rustyfishbones — Thu, 29 Aug 2013 13:05:21 GMT

Thanks, that works