Another Set Analysis issue

justinasp — Fri, 26 Feb 2010 16:19:18 GMT

Hi, guys,

I need to sum sales for supply scheme A1 in all branches and A1,A2 schemes in Office. Using IF(..) statement, it would be

sum(if(supp_scheme='A1' or bra_id='OFI', sales))

However it is part of set analysis, so I need to write it in that style. It could be something like

sum({<supp_scheme={'A1'} - {"bra_id='OFI'"}>} sales)

Any ideas would be appreciated,

Justinas

jagan — Fri, 26 Feb 2010 17:36:44 GMT

I hope the following is you are looking for.

sum({<supp_scheme={$(=if(bra_id='OFI', 'A1,A2', 'A1'))}>}sales)

Regards

topic Another Set Analysis issue in QlikView