Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Set Analysis question

Hi All

What would be the Set analysis statement to select following ? Please help

sum( {<Product A with Type 'Regular'  and  Product B with Type 'Regular' & 'Adv'>} sales)

ProductType
ARegular
BRegular
BAdv
1 Solution

Accepted Solutions
Highlighted
Specialist II
Specialist II

sum( {<Product=P({<Product={'A'},Type={'Regular'}>} Product)>} sales) + sum( {<Product=P({<Product={'B'},Type={'Regular','Adv'}>} Product)>} sales)

View solution in original post

5 Replies
Highlighted
Specialist
Specialist

maybe:

sum( {<Product=A, Type 'Regular'>} sales)

+

sum( {<Product=B,Type 'Regular'>} sales)

+

sum( {<Product=B,Type 'Adv'>} sales)

Highlighted
Specialist II
Specialist II

sum( {<Product=P({<Product={'A'},Type={'Regular'}>} Product)>} sales) + sum( {<Product=P({<Product={'B'},Type={'Regular','Adv'}>} Product)>} sales)

View solution in original post

Highlighted
Creator III
Creator III

Hi Rashid,

The easy work around can be merge these two columns into one in data model and name it as producttype and you can use below expression.

Sum({<product type = {'ARegular' ,'BRegular' , 'BAdv' } >} sales)

Regards,

Akshaya

Highlighted
Specialist
Specialist

sum( {<Product=A, Type='Regular'>} sales)+sum( {<Product=B,Type='Regular','Adv'>} sales)

Highlighted
Creator
Creator

Thanks