topic Need help in KPI calculation to select specific row data in App Development https://community.qlik.com/t5/App-Development/Need-help-in-KPI-calculation-to-select-specific-row-data/m-p/1938295#M77332 <P>Hi All,</P> <P>I need to calculate a formula which should be the value of "InitialAttemptedToSetup" for 'QciIndex' =2</P> <P>Can anyone suggest me how to get this calculation where&nbsp;InitialAttemptedToSetup value of QciIndex=2 is selected</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="airspansvg_0-1654081299382.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/80793i91C38726DFB20ED1/image-size/medium?v=v2&amp;px=400" role="button" title="airspansvg_0-1654081299382.png" alt="airspansvg_0-1654081299382.png" /></span></P> <P>&nbsp;</P> Wed, 01 Jun 2022 11:05:31 GMT airspansvg 2022-06-01T11:05:31Z Need help in KPI calculation to select specific row data https://community.qlik.com/t5/App-Development/Need-help-in-KPI-calculation-to-select-specific-row-data/m-p/1938295#M77332 <P>Hi All,</P> <P>I need to calculate a formula which should be the value of "InitialAttemptedToSetup" for 'QciIndex' =2</P> <P>Can anyone suggest me how to get this calculation where&nbsp;InitialAttemptedToSetup value of QciIndex=2 is selected</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="airspansvg_0-1654081299382.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/80793i91C38726DFB20ED1/image-size/medium?v=v2&amp;px=400" role="button" title="airspansvg_0-1654081299382.png" alt="airspansvg_0-1654081299382.png" /></span></P> <P>&nbsp;</P> Wed, 01 Jun 2022 11:05:31 GMT https://community.qlik.com/t5/App-Development/Need-help-in-KPI-calculation-to-select-specific-row-data/m-p/1938295#M77332 airspansvg 2022-06-01T11:05:31Z Re: Need help in KPI calculation to select specific row data https://community.qlik.com/t5/App-Development/Need-help-in-KPI-calculation-to-select-specific-row-data/m-p/1938307#M77334 <P>Hi</P> <P>may be this :</P> <P>&nbsp;</P> <P>sum({&lt;<SPAN>QciIndex={'2'}</SPAN>&gt;}&nbsp;<SPAN>InitialAttemptedToSetup)</SPAN></P> Wed, 01 Jun 2022 11:18:57 GMT https://community.qlik.com/t5/App-Development/Need-help-in-KPI-calculation-to-select-specific-row-data/m-p/1938307#M77334 brunobertels 2022-06-01T11:18:57Z