Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
rustyfishbones
Honored Contributor II

Limit Product Table by Sales

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

1 Solution

Accepted Solutions

Re: Limit Product Table by Sales

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.


talk is cheap, supply exceeds demand
2 Replies

Re: Limit Product Table by Sales

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.


talk is cheap, supply exceeds demand
rustyfishbones
Honored Contributor II

Re: Limit Product Table by Sales

Thanks, that works

Community Browser