Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
The situation:
I have an app with 6 nonzero variables: var1, var2, ... var6.
I use data from excel that is a very large table.
When some filters are applied in qlik, the table reduces and a specific cell will exist or not exist based on a matchup of a name column to a number column (Var1 in name column and "x" in number column). I would like to sum the var1's to var6's in qlik based on if the cell matchup exists (if it does add together if it doesn't make it 0).
I believe this problem should be solved with a loop as there are a LARGE number of combinations of which of the 6 variables requirements are met or not met.
Thank you!
RangeSum(var1, var2, var3, var4, var5, var6)
-Rob