Help with set analysis needed

[#1]

Hi all

sum({<[Fact.Type] = {'Open_Orders'}, [Fact.Type] = {'Sales'},[Fact.Type] = {'ThirdParty'}>}Fact.Net_Rev_EUR)

this is the formula I have, unfortunately QlikView calculates only the last Fact.Type (ThirdParty). When I take out "ThirdParty", then it calculates the sum of "Sales" ....

Strange, isn't it?

thanks for your help

Oliver

[tresB · Accepted solution]

Try like:

sum({<[Fact.Type] = {'Open_Orders','Sales','ThirdParty'}>}Fact.Net_Rev_EUR)

[ashwanin]

Hi

Try this.

sum({<[Fact.Type] = {'Open_Orders','Sales','ThirdParty'}>}Fact.Net_Rev_EUR)

[anbu1984]

sum({<[Fact.Type] = {'Open_Orders','Sales','ThirdParty'}>}Fact.Net_Rev_EUR)

[#5]

cool - sometimes its so easy but it's just hard to see 🙂

Thanks a lot

Oliver