Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rustyfishbones
Master II
Master 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
Gysbert_Wassenaar

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

View solution in original post

2 Replies
Gysbert_Wassenaar

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
Master II
Master II
Author

Thanks, that works