Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
rmuhammad
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
jwjackso
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
wdchristensen
Specialist
Specialist

maybe:

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

+

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

+

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

jwjackso
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

adityaakshaya
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

wdchristensen
Specialist
Specialist

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

rmuhammad
Creator
Creator
Author

Thanks