Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

leobrand
New Contributor

Combine Set Expressions

I want to create a set expression that includes customers that purchased “Running Shoe A” while excluding customers that purchased this shoe from the vendor “Sporting Goods Store”.  Can you help me combine the set expressions below into one in order to do this?

Sum({1<Customer=(P({1<ProductName={Running Shoe A}>}))>}LineSalesAmount)

Sum({1<Customer=(E({1<Vendor={Sporting Goods Store}>}))>}LineSalesAmount)

2 Replies

Re: Combine Set Expressions

May be this

Sum({1<Customer=P({1<ProductName={Running Shoe A}>})*E({1<Vendor={Sporting Goods Store}>})>}LineSalesAmount)

Re: Combine Set Expressions

Or one of these

Sum({1<Customer=P({1<ProductName = {'Running Shoe A'}>})*E({1<Vendor={'Sporting Goods Store'}, ProductName = {'Running Shoe A'}>}), ProductName = {'Running Shoe A'}>}LineSalesAmount)

Sum({1<Customer=P({1<ProductName = {'Running Shoe A'}>})*E({1<Vendor={'Sporting Goods Store'}, ProductName = {'Running Shoe A'}>})>}LineSalesAmount)

Community Browser