topic Set Analysis to calculate Proportional Increase for positive values only in App Development https://community.qlik.com/t5/App-Development/Set-Analysis-to-calculate-Proportional-Increase-for-positive/m-p/1731683#M55837 <P>Hello</P><P>I have a Dimension 'Customer' and I would like to work out the proportion of increase from 2019 to 2020, only if they had a positive Sales.</P><P>Can anybody help me with the set analysis please to work out the Proportional Increase?</P><P>Kelly</P><P>&nbsp;</P><TABLE width="357"><TBODY><TR><TD width="76">Customer</TD><TD width="139">2019 to 2020 Increase</TD><TD width="142">Proportional Increase</TD></TR><TR><TD>CustomerA</TD><TD>-100</TD><TD>&nbsp;</TD></TR><TR><TD>CustomerB</TD><TD>200</TD><TD>50%</TD></TR><TR><TD>CustomerC</TD><TD>200</TD><TD>50%</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>Total&nbsp;</TD><TD>400</TD><TD>100%</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Wed, 22 Dec 2021 16:26:04 GMT kcville 2021-12-22T16:26:04Z Set Analysis to calculate Proportional Increase for positive values only https://community.qlik.com/t5/App-Development/Set-Analysis-to-calculate-Proportional-Increase-for-positive/m-p/1731683#M55837 <P>Hello</P><P>I have a Dimension 'Customer' and I would like to work out the proportion of increase from 2019 to 2020, only if they had a positive Sales.</P><P>Can anybody help me with the set analysis please to work out the Proportional Increase?</P><P>Kelly</P><P>&nbsp;</P><TABLE width="357"><TBODY><TR><TD width="76">Customer</TD><TD width="139">2019 to 2020 Increase</TD><TD width="142">Proportional Increase</TD></TR><TR><TD>CustomerA</TD><TD>-100</TD><TD>&nbsp;</TD></TR><TR><TD>CustomerB</TD><TD>200</TD><TD>50%</TD></TR><TR><TD>CustomerC</TD><TD>200</TD><TD>50%</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>Total&nbsp;</TD><TD>400</TD><TD>100%</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Wed, 22 Dec 2021 16:26:04 GMT https://community.qlik.com/t5/App-Development/Set-Analysis-to-calculate-Proportional-Increase-for-positive/m-p/1731683#M55837 kcville 2021-12-22T16:26:04Z Re: Set Analysis to calculate Proportional Increase for positive values only https://community.qlik.com/t5/App-Development/Set-Analysis-to-calculate-Proportional-Increase-for-positive/m-p/1732618#M55912 <P>Just Create another Dimension Field in the Script:</P><P>if(Value&gt;=0,Value)) as PositiveValue</P><P>and write the SetExpression with this Field</P> Sun, 02 Aug 2020 07:20:01 GMT https://community.qlik.com/t5/App-Development/Set-Analysis-to-calculate-Proportional-Increase-for-positive/m-p/1732618#M55912 H_Julian 2020-08-02T07:20:01Z