Discussion Board for collaboration on QlikView Scripting.
I am using direct discovery for my fact table. using aggregate function and if condition that time failed the expression.
Case 1 : Sum(Amount) -- Working
Case 2 : if(REGION='ALL',Amount,0) -- Working
Case 3 : Sum(if(REGION='ALL',Amount,0) ) -- Failed
How to solve the problem in case 3.
pls , help for me.
It should work
just try out in direct discovery method, it's not working.