Discussion Board for collaboration on QlikView Scripting.
In a listBox, I want to calculate the sum of multiple entities based on the following formula: if (X = 200 OR Y = 381, sum (if (Z = 4, amount, 0)), 0) listBox does not work with SUM. while the same expression works well in another table in the same sheet.
Go to Solution.
You could achieve similar output with proper use of Aggr(). Try to share a sample qvw with sample data explaining expected output.
Can you not do your formula in the script and name it as a field?
Aggr() seems resolving the problem. your help was very helpful, thank you.