topic Looping in chart script if a cell exists after filters are applied in App Development https://community.qlik.com/t5/App-Development/Looping-in-chart-script-if-a-cell-exists-after-filters-are/m-p/2454853#M98360 <P>The situation:</P> <P>I have an app with 6 nonzero variables: var1, var2, ... var6.</P> <P>I use data from excel that is a very large table.</P> <P>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).&nbsp;</P> <P>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.</P> <P>Thank you!</P> Tue, 21 May 2024 18:21:50 GMT mcsmithums1 2024-05-21T18:21:50Z Looping in chart script if a cell exists after filters are applied https://community.qlik.com/t5/App-Development/Looping-in-chart-script-if-a-cell-exists-after-filters-are/m-p/2454853#M98360 <P>The situation:</P> <P>I have an app with 6 nonzero variables: var1, var2, ... var6.</P> <P>I use data from excel that is a very large table.</P> <P>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).&nbsp;</P> <P>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.</P> <P>Thank you!</P> Tue, 21 May 2024 18:21:50 GMT https://community.qlik.com/t5/App-Development/Looping-in-chart-script-if-a-cell-exists-after-filters-are/m-p/2454853#M98360 mcsmithums1 2024-05-21T18:21:50Z Re: Looping in chart script if a cell exists after filters are applied https://community.qlik.com/t5/App-Development/Looping-in-chart-script-if-a-cell-exists-after-filters-are/m-p/2455261#M98406 <P>RangeSum(var1, var2, var3, var4, var5, var6)</P> <P>-Rob</P> Wed, 22 May 2024 14:13:05 GMT https://community.qlik.com/t5/App-Development/Looping-in-chart-script-if-a-cell-exists-after-filters-are/m-p/2455261#M98406 rwunderlich 2024-05-22T14:13:05Z