topic Set Analysis with OR in P function in QlikView

Set Analysis with OR in P function

hugmarcel — Wed, 26 Aug 2015 10:13:19 GMT

I want to calculate the sum of sales for all compaigns (main dimension) which are part

of either the sales-b campaigns or the sales-c campaigns (sub dimensions).

How can it be done? Something like

SUM({<CAMPAIGN=P([SALES_B CAMPAIGN]) OR CAMPAIGN=P([SALES_C CAMPAIGN])<} SALES)

does not work.

Thank you!

Marcel

tresB — Wed, 26 Aug 2015 10:15:50 GMT

May be like:

SUM({<CAMPAIGN=P([SALES_B CAMPAIGN])> + < CAMPAIGN=P([SALES_C CAMPAIGN])>} SALES)

hugmarcel — Thu, 27 Aug 2015 07:54:40 GMT

Thank you, that's fine!

What is the correct formula if I want to have all campaigns which are

in ( [SALES_B CAMPAIGN] OR [SALES_C CAMPAIGN] ) but NOT in [SALES_D CAMPAIGN]

Thank you! Marcel

tresB — Thu, 27 Aug 2015 08:05:31 GMT

This?

SUM({<CAMPAIGN=P([SALES_B CAMPAIGN])> + < CAMPAIGN=P([SALES_C CAMPAIGN])> - < CAMPAIGN=P([SALES_D CAMPAIGN])>} SALES)