https://community.qlik.com/t5/QlikView/Want-to-find-the-StDev-value/m-p/2508816#M1226465 <P>It depends on your data structure, and whether you want the result as a standalone KPI or as part of a table.</P> <P>You say you have 10 values in the spray field, so I assume the data structure is something like this:&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Ben_P_0-1741365377780.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/178276iA2C87B6644ADA0D8/image-size/medium?v=v2&amp;px=400" role="button" title="Ben_P_0-1741365377780.png" alt="Ben_P_0-1741365377780.png" /></span></P> <P>In this case, if you want a KPI showing stdev for all Top side values, something like this should work:</P> <P>if([Panel side]='Top side',stdev(Value))</P> Fri, 07 Mar 2025 16:40:02 GMT Ben_P 2025-03-07T16:40:02Z https://community.qlik.com/t5/QlikView/Want-to-find-the-StDev-value/m-p/2508721#M1226464 <P>I have 10 values ​​in Spray field as shown in the figure. I want to find the StDev total of Panel Side = Top side regardless of Axis. In Excel, I would drag the mouse from Spart1 of Axis 1 to Spray1 and then spray10.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Paknanarn23_0-1741334033672.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/178246iC3A8DCE7C2013AB2/image-size/medium?v=v2&amp;px=400" role="button" title="Paknanarn23_0-1741334033672.png" alt="Paknanarn23_0-1741334033672.png" /></span></P> <P>What should I do?</P> Fri, 07 Mar 2025 07:54:14 GMT https://community.qlik.com/t5/QlikView/Want-to-find-the-StDev-value/m-p/2508721#M1226464 Paknanarn23 2025-03-07T07:54:14Z https://community.qlik.com/t5/QlikView/Want-to-find-the-StDev-value/m-p/2508816#M1226465 <P>It depends on your data structure, and whether you want the result as a standalone KPI or as part of a table.</P> <P>You say you have 10 values in the spray field, so I assume the data structure is something like this:&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Ben_P_0-1741365377780.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/178276iA2C87B6644ADA0D8/image-size/medium?v=v2&amp;px=400" role="button" title="Ben_P_0-1741365377780.png" alt="Ben_P_0-1741365377780.png" /></span></P> <P>In this case, if you want a KPI showing stdev for all Top side values, something like this should work:</P> <P>if([Panel side]='Top side',stdev(Value))</P> Fri, 07 Mar 2025 16:40:02 GMT https://community.qlik.com/t5/QlikView/Want-to-find-the-StDev-value/m-p/2508816#M1226465 Ben_P 2025-03-07T16:40:02Z https://community.qlik.com/t5/QlikView/Want-to-find-the-StDev-value/m-p/2508865#M1226466 <P>I want to find all values ​​of Spray 1-10 ignoring Axis.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Paknanarn23_0-1741423733613.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/178288iFBE245C30141563A/image-size/medium?v=v2&amp;px=400" role="button" title="Paknanarn23_0-1741423733613.png" alt="Paknanarn23_0-1741423733613.png" /></span></P> <P>This is a formula in Excel.</P> Sat, 08 Mar 2025 08:49:08 GMT https://community.qlik.com/t5/QlikView/Want-to-find-the-StDev-value/m-p/2508865#M1226466 Paknanarn23 2025-03-08T08:49:08Z