topic Re: Set Analysis question in QlikView

Set Analysis question

rmuhammad — Wed, 25 Nov 2020 16:16:04 GMT

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)

wdchristensen — Wed, 21 Mar 2018 14:09:07 GMT

maybe:

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

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

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

jwjackso — Wed, 21 Mar 2018 14:10:52 GMT

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

adityaakshaya — Wed, 21 Mar 2018 14:11:06 GMT

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 — Wed, 21 Mar 2018 14:12:10 GMT

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

rmuhammad — Wed, 21 Mar 2018 14:19:55 GMT

Thanks