I am trying to use the Outer Set Expression with Total function and it doesn't give me the expected results (i.e. same result as Inner ).
Measure 1 using Inner : sum( {<ExpYrWk = {'202306'}>} Total Vol)
Measure 2 using Outer : {<ExpYrWk = {'202306'}>} sum(Total Vol)
![lost_rabbit_0-1678135129566.png lost_rabbit_0-1678135129566.png](https://community.qlik.com/t5/image/serverpage/image-id/102116iAB4C929082B043F5/image-size/medium?v=v2&px=400)
I expected both to give the same result. I am trying to use outer set expression to make my formulas look more easy to read and write.
For eg, When I am doing % calculations using Total function with multiple conditions, it becomes a hassle when I have to use multiple conditions like below
sum( {<ExpYrWk = {'202306'},Carrier={'APL'}, ShippingTypeCd = {'E E'}>} Vol)
/
sum( {<ExpYrWk = {'202306'}, Carrier={'APL'}, ShippingTypeCd = {'E E'}>} total Vol)
Would be easier If I could write something like this instead :
{<ExpYrWk = {'202306'},Carrier={'APL'}, ShippingTypeCd = {'E E'}>} sum( Vol) / sum( total Vol)
Thanks in advance