topic Re: Calculate i MasterItems in App Development https://community.qlik.com/t5/App-Development/Calculate-i-MasterItems/m-p/2049941#M86304 <P>Clearify:</P> <TABLE style="border-collapse: collapse; width: 96pt;" border="0" width="128" cellspacing="0" cellpadding="0"> <TBODY> <TR style="height: 12.75pt;"> <TD width="64" height="17" class="xl67" style="height: 12.75pt; width: 48pt;">Net</TD> <TD width="64" align="right" class="xl66" style="border-left: none; width: 48pt;">105600</TD> </TR> <TR style="height: 12.75pt;"> <TD height="17" class="xl65" style="height: 12.75pt; border-top: none;">&nbsp;</TD> <TD class="xl66" style="border-top: none; border-left: none;">&nbsp;</TD> </TR> <TR style="height: 12.75pt;"> <TD height="17" class="xl67" style="height: 12.75pt; border-top: none;">Other</TD> <TD align="right" class="xl66" style="border-top: none; border-left: none;">6000</TD> </TR> <TR style="height: 12.75pt;"> <TD height="17" class="xl65" style="height: 12.75pt; border-top: none;">&nbsp;</TD> <TD class="xl65" style="border-top: none; border-left: none;">&nbsp;</TD> </TR> <TR style="height: 12.75pt;"> <TD height="17" class="xl65" style="height: 12.75pt; border-top: none;">&nbsp;</TD> <TD class="xl67" style="border-top: none; border-left: none;">&nbsp;</TD> </TR> <TR style="height: 12.75pt;"> <TD height="17" class="xl67" style="height: 12.75pt; border-top: none;">In %</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1116</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>The "In %" is calculated in EXCEL:&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="johnan_0-1678958086331.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/102914iBA813B69E9775A84/image-size/medium?v=v2&amp;px=400" role="button" title="johnan_0-1678958086331.png" alt="johnan_0-1678958086331.png" /></span></P> <P>&nbsp;</P> Thu, 16 Mar 2023 09:30:07 GMT johnan 2023-03-16T09:30:07Z Calculate i MasterItems https://community.qlik.com/t5/App-Development/Calculate-i-MasterItems/m-p/2049901#M86298 <P>Hi,&nbsp; I have calculate 4 master items to one.</P> <P>Then a want to add %</P> <P>Is that possible?</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="johnan_0-1678955405588.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/102898i24D19FF9B746AFBB/image-size/medium?v=v2&amp;px=400" role="button" title="johnan_0-1678955405588.png" alt="johnan_0-1678955405588.png" /></span></P> <P>&nbsp;</P> Thu, 16 Mar 2023 08:30:46 GMT https://community.qlik.com/t5/App-Development/Calculate-i-MasterItems/m-p/2049901#M86298 johnan 2023-03-16T08:30:46Z Re: Calculate i MasterItems https://community.qlik.com/t5/App-Development/Calculate-i-MasterItems/m-p/2049941#M86304 <P>Clearify:</P> <TABLE style="border-collapse: collapse; width: 96pt;" border="0" width="128" cellspacing="0" cellpadding="0"> <TBODY> <TR style="height: 12.75pt;"> <TD width="64" height="17" class="xl67" style="height: 12.75pt; width: 48pt;">Net</TD> <TD width="64" align="right" class="xl66" style="border-left: none; width: 48pt;">105600</TD> </TR> <TR style="height: 12.75pt;"> <TD height="17" class="xl65" style="height: 12.75pt; border-top: none;">&nbsp;</TD> <TD class="xl66" style="border-top: none; border-left: none;">&nbsp;</TD> </TR> <TR style="height: 12.75pt;"> <TD height="17" class="xl67" style="height: 12.75pt; border-top: none;">Other</TD> <TD align="right" class="xl66" style="border-top: none; border-left: none;">6000</TD> </TR> <TR style="height: 12.75pt;"> <TD height="17" class="xl65" style="height: 12.75pt; border-top: none;">&nbsp;</TD> <TD class="xl65" style="border-top: none; border-left: none;">&nbsp;</TD> </TR> <TR style="height: 12.75pt;"> <TD height="17" class="xl65" style="height: 12.75pt; border-top: none;">&nbsp;</TD> <TD class="xl67" style="border-top: none; border-left: none;">&nbsp;</TD> </TR> <TR style="height: 12.75pt;"> <TD height="17" class="xl67" style="height: 12.75pt; border-top: none;">In %</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1116</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>The "In %" is calculated in EXCEL:&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="johnan_0-1678958086331.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/102914iBA813B69E9775A84/image-size/medium?v=v2&amp;px=400" role="button" title="johnan_0-1678958086331.png" alt="johnan_0-1678958086331.png" /></span></P> <P>&nbsp;</P> Thu, 16 Mar 2023 09:30:07 GMT https://community.qlik.com/t5/App-Development/Calculate-i-MasterItems/m-p/2049941#M86304 johnan 2023-03-16T09:30:07Z Re: Calculate i MasterItems https://community.qlik.com/t5/App-Development/Calculate-i-MasterItems/m-p/2050061#M86320 <P>I build a solution, added 2 master items and divied by 100, then calculate master item 1 + master item 2<BR />Sometimes i miss QlikView <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Thu, 16 Mar 2023 12:28:15 GMT https://community.qlik.com/t5/App-Development/Calculate-i-MasterItems/m-p/2050061#M86320 johnan 2023-03-16T12:28:15Z