Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try like:
sum({<[Fact.Type] = {'Open_Orders','Sales','ThirdParty'}>}Fact.Net_Rev_EUR)
Try like:
sum({<[Fact.Type] = {'Open_Orders','Sales','ThirdParty'}>}Fact.Net_Rev_EUR)
Hi
Try this.
sum({<[Fact.Type] = {'Open_Orders','Sales','ThirdParty'}>}Fact.Net_Rev_EUR)
sum({<[Fact.Type] = {'Open_Orders','Sales','ThirdParty'}>}Fact.Net_Rev_EUR)
cool - sometimes its so easy but it's just hard to see 🙂
Thanks a lot
Oliver