topic Re: Help with set analysis needed in QlikView

Help with set analysis needed

Thu, 20 Nov 2014 07:43:24 GMT

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

Re: Help with set analysis needed

tresB — Thu, 20 Nov 2014 07:46:44 GMT

Try like:

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

Re: Help with set analysis needed

ashwanin — Thu, 20 Nov 2014 07:47:05 GMT

Try this.

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

Re: Help with set analysis needed

anbu1984 — Thu, 20 Nov 2014 07:47:47 GMT

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

Re: Help with set analysis needed

Thu, 20 Nov 2014 07:51:02 GMT

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

Thanks a lot

Oliver