How to use positive and negative logic simulatniously in Set Analysis

[#1]

Hi there

I have 2 statements I would like to use in one Set Analysis statement. Individually they work a charm, but together I have no luck:

Statement 1:sum({$-1<ProductBrand = {'*Certificate*', '*Bank*'}>} NrOfExchTxns) // In this statement I want all Txns where the ProductBrand is not Certificate or Bank

Statement 2:

sum({$<CallMade={1}>} NrOfExchTxns)  // In This statement I want all Txns where the CallMade value = 1

Pretty simple one would think, but I have tried various scripts with the following being my latest stab at it, with no positive result:

sum( {$<CallMade = {"=sum({$-1<ProductBrand = {'*Certificate*', '*Spacebank*'}>}  NrOfExchTxns) = {1}"}>} NrOfExchTxns )

Any suggestions?

Many thanks

Paul

[daveamz]

Hello,

     For the 1st statement if you use QV 10, try:

      sum({<ProductBrand =ProductBrand- {'*Certificate*', '*Bank*'}>} NrOfExchTxns) // to sum all the Txns where ProductBrand is not Certificate or Bank.

     In QV 9 the statement will be:

     sum({<ProductBrand -= {'*Certificate*', '*Bank*'}>} NrOfExchTxns)

See the example attached.

[#3]

Hi there Dave

Thanks for the reply, but I was looking to incorporate both statements in one set analysis.

My problem was that the one used negative logic: $-1 and the other use positive logic $, and I did not know how to incorporate both in one statement. I have found a workaround by using posive logic in both statements $, and thereby easily combining the two.

sum({$<ProductBrand = {'*Local*', '*International*'}, CallMade={1}>} NrOfExchTxns)

In the statement above Local and International are the opposite of Certificate and Bank

If anybody else knows how to incorporate the $-1 and # in one statement I'd appreciate it

thanks

[#4]

Sorry man, I meant to end the message with:

If anybody else knows how to incorporate the $-1 and $ in one statement I'd appreciate it

rather than:

If anybody else knows how to incorporate the $-1 and # in one statement I'd appreciate it

[sicilianif · Accepted solution]

Try:

sum({<ProductBrand -= {'*Certificate*', '*Bank*'}, CallMade={1}>} NrOfExchTxns)

[#6]

That did it

Many thanks!