https://community.qlik.com/t5/App-Development/Pivot-Table/m-p/1912689#M75229 <P>Hi</P> <P>1) I am working on pivot table where i have multiple calculation involved like stdev and z-score.</P> <P>Below is the sample table where I need to calculate stdev for Q1 , Q2, Q3, Q4&nbsp; so it has to pass values of company into stdev function stdev(8,2,0,0,0) for Q1 etc....&nbsp; ( the values in pivot table&nbsp; used formula with few conditions)</P> <P>That result I need to store in array where i can use&nbsp; for z-score&nbsp;</P> <TABLE style="border-collapse: collapse; width: 240pt;" border="0" width="320" cellspacing="0" cellpadding="0"> <TBODY> <TR style="height: 14.5pt;"> <TD width="75px" height="14px" class="xl63" style="height: 14.5pt; width: 48pt;">Company</TD> <TD width="61px" height="14px" class="xl63" style="border-left: none; width: 48pt;">Q1</TD> <TD width="61px" height="14px" class="xl63" style="border-left: none; width: 48pt;">Q2</TD> <TD width="61px" height="14px" class="xl63" style="border-left: none; width: 48pt;">Q3</TD> <TD width="61px" height="14px" class="xl63" style="border-left: none; width: 48pt;">Q4</TD> </TR> <TR style="height: 14.5pt;"> <TD width="75px" height="14px" class="xl64" style="height: 14.5pt; border-top: none;">A</TD> <TD width="61px" height="14px" align="right" class="xl65" style="border-top: none; border-left: none;">8</TD> <TD width="61px" height="14px" align="right" class="xl65" style="border-top: none; border-left: none;">4</TD> <TD width="61px" height="14px" align="right" class="xl65" style="border-top: none; border-left: none;">0</TD> <TD width="61px" height="14px" align="right" class="xl65" style="border-top: none; border-left: none;">7</TD> </TR> <TR style="height: 14.5pt;"> <TD width="75px" height="14px" class="xl64" style="height: 14.5pt; border-top: none;">B</TD> <TD width="61px" height="14px" align="right" class="xl65" style="border-top: none; border-left: none;">2</TD> <TD width="61px" height="14px" align="right" class="xl65" style="border-top: none; border-left: none;">0</TD> <TD width="61px" height="14px" align="right" class="xl65" style="border-top: none; border-left: none;">5</TD> <TD width="61px" height="14px" align="right" class="xl65" style="border-top: none; border-left: none;">2</TD> </TR> <TR style="height: 14.5pt;"> <TD width="75px" height="14px" class="xl64" style="height: 14.5pt; border-top: none;">C</TD> <TD width="61px" height="14px" align="right" class="xl65" style="border-top: none; border-left: none;">0</TD> <TD width="61px" height="14px" align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD width="61px" height="14px" align="right" class="xl65" style="border-top: none; border-left: none;">0</TD> <TD width="61px" height="14px" align="right" class="xl65" style="border-top: none; border-left: none;">0</TD> </TR> <TR style="height: 14.5pt;"> <TD width="75px" height="14px" class="xl64" style="height: 14.5pt; border-top: none;">D</TD> <TD width="61px" height="14px" align="right" class="xl65" style="border-top: none; border-left: none;">0</TD> <TD width="61px" height="14px" align="right" class="xl65" style="border-top: none; border-left: none;">0</TD> <TD width="61px" height="14px" align="right" class="xl65" style="border-top: none; border-left: none;">2</TD> <TD width="61px" height="14px" align="right" class="xl65" style="border-top: none; border-left: none;">0</TD> </TR> <TR style="height: 14.5pt;"> <TD width="75px" height="14px" class="xl64" style="height: 14.5pt; border-top: none;">E</TD> <TD width="61px" height="14px" align="right" class="xl65" style="border-top: none; border-left: none;">0</TD> <TD width="61px" height="14px" align="right" class="xl65" style="border-top: none; border-left: none;">2</TD> <TD width="61px" height="14px" align="right" class="xl65" style="border-top: none; border-left: none;">0</TD> <TD width="61px" height="14px" align="right" class="xl65" style="border-top: none; border-left: none;">4</TD> </TR> <TR style="height: 14.5pt;"> <TD width="75px" height="14px" class="xl64" style="height: 14.5pt; border-top: none;">F</TD> <TD width="61px" height="14px" align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD width="61px" height="14px" align="right" class="xl65" style="border-top: none; border-left: none;">0</TD> <TD width="61px" height="14px" align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD width="61px" height="14px" align="right" class="xl65" style="border-top: none; border-left: none;">2</TD> </TR> <TR style="height: 14.5pt;"> <TD width="75px" height="14px" class="xl66" style="height: 14.5pt; border-top: none;">Total</TD> <TD width="61px" height="14px" align="right" class="xl66" style="border-top: none; border-left: none;">11</TD> <TD width="61px" height="14px" align="right" class="xl66" style="border-top: none; border-left: none;">9</TD> <TD width="61px" height="14px" align="right" class="xl66" style="border-top: none; border-left: none;">10</TD> <TD width="61px" height="14px" align="right" class="xl66" style="border-top: none; border-left: none;">15</TD> </TR> <TR style="height: 14.5pt;"> <TD width="75px" height="14px" class="xl67" style="height: 14.5pt;">Stdev</TD> <TD width="61px" height="14px">&nbsp;</TD> <TD width="61px" height="14px">&nbsp;</TD> <TD width="61px" height="14px">&nbsp;</TD> <TD width="61px" height="14px">&nbsp;</TD> </TR> </TBODY> </TABLE> Thu, 31 Mar 2022 17:54:03 GMT kavirao 2022-03-31T17:54:03Z https://community.qlik.com/t5/App-Development/Pivot-Table/m-p/1912689#M75229 <P>Hi</P> <P>1) I am working on pivot table where i have multiple calculation involved like stdev and z-score.</P> <P>Below is the sample table where I need to calculate stdev for Q1 , Q2, Q3, Q4&nbsp; so it has to pass values of company into stdev function stdev(8,2,0,0,0) for Q1 etc....&nbsp; ( the values in pivot table&nbsp; used formula with few conditions)</P> <P>That result I need to store in array where i can use&nbsp; for z-score&nbsp;</P> <TABLE style="border-collapse: collapse; width: 240pt;" border="0" width="320" cellspacing="0" cellpadding="0"> <TBODY> <TR style="height: 14.5pt;"> <TD width="75px" height="14px" class="xl63" style="height: 14.5pt; width: 48pt;">Company</TD> <TD width="61px" height="14px" class="xl63" style="border-left: none; width: 48pt;">Q1</TD> <TD width="61px" height="14px" class="xl63" style="border-left: none; width: 48pt;">Q2</TD> <TD width="61px" height="14px" class="xl63" style="border-left: none; width: 48pt;">Q3</TD> <TD width="61px" height="14px" class="xl63" style="border-left: none; width: 48pt;">Q4</TD> </TR> <TR style="height: 14.5pt;"> <TD width="75px" height="14px" class="xl64" style="height: 14.5pt; border-top: none;">A</TD> <TD width="61px" height="14px" align="right" class="xl65" style="border-top: none; border-left: none;">8</TD> <TD width="61px" height="14px" align="right" class="xl65" style="border-top: none; border-left: none;">4</TD> <TD width="61px" height="14px" align="right" class="xl65" style="border-top: none; border-left: none;">0</TD> <TD width="61px" height="14px" align="right" class="xl65" style="border-top: none; border-left: none;">7</TD> </TR> <TR style="height: 14.5pt;"> <TD width="75px" height="14px" class="xl64" style="height: 14.5pt; border-top: none;">B</TD> <TD width="61px" height="14px" align="right" class="xl65" style="border-top: none; border-left: none;">2</TD> <TD width="61px" height="14px" align="right" class="xl65" style="border-top: none; border-left: none;">0</TD> <TD width="61px" height="14px" align="right" class="xl65" style="border-top: none; border-left: none;">5</TD> <TD width="61px" height="14px" align="right" class="xl65" style="border-top: none; border-left: none;">2</TD> </TR> <TR style="height: 14.5pt;"> <TD width="75px" height="14px" class="xl64" style="height: 14.5pt; border-top: none;">C</TD> <TD width="61px" height="14px" align="right" class="xl65" style="border-top: none; border-left: none;">0</TD> <TD width="61px" height="14px" align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD width="61px" height="14px" align="right" class="xl65" style="border-top: none; border-left: none;">0</TD> <TD width="61px" height="14px" align="right" class="xl65" style="border-top: none; border-left: none;">0</TD> </TR> <TR style="height: 14.5pt;"> <TD width="75px" height="14px" class="xl64" style="height: 14.5pt; border-top: none;">D</TD> <TD width="61px" height="14px" align="right" class="xl65" style="border-top: none; border-left: none;">0</TD> <TD width="61px" height="14px" align="right" class="xl65" style="border-top: none; border-left: none;">0</TD> <TD width="61px" height="14px" align="right" class="xl65" style="border-top: none; border-left: none;">2</TD> <TD width="61px" height="14px" align="right" class="xl65" style="border-top: none; border-left: none;">0</TD> </TR> <TR style="height: 14.5pt;"> <TD width="75px" height="14px" class="xl64" style="height: 14.5pt; border-top: none;">E</TD> <TD width="61px" height="14px" align="right" class="xl65" style="border-top: none; border-left: none;">0</TD> <TD width="61px" height="14px" align="right" class="xl65" style="border-top: none; border-left: none;">2</TD> <TD width="61px" height="14px" align="right" class="xl65" style="border-top: none; border-left: none;">0</TD> <TD width="61px" height="14px" align="right" class="xl65" style="border-top: none; border-left: none;">4</TD> </TR> <TR style="height: 14.5pt;"> <TD width="75px" height="14px" class="xl64" style="height: 14.5pt; border-top: none;">F</TD> <TD width="61px" height="14px" align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> <TD width="61px" height="14px" align="right" class="xl65" style="border-top: none; border-left: none;">0</TD> <TD width="61px" height="14px" align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> <TD width="61px" height="14px" align="right" class="xl65" style="border-top: none; border-left: none;">2</TD> </TR> <TR style="height: 14.5pt;"> <TD width="75px" height="14px" class="xl66" style="height: 14.5pt; border-top: none;">Total</TD> <TD width="61px" height="14px" align="right" class="xl66" style="border-top: none; border-left: none;">11</TD> <TD width="61px" height="14px" align="right" class="xl66" style="border-top: none; border-left: none;">9</TD> <TD width="61px" height="14px" align="right" class="xl66" style="border-top: none; border-left: none;">10</TD> <TD width="61px" height="14px" align="right" class="xl66" style="border-top: none; border-left: none;">15</TD> </TR> <TR style="height: 14.5pt;"> <TD width="75px" height="14px" class="xl67" style="height: 14.5pt;">Stdev</TD> <TD width="61px" height="14px">&nbsp;</TD> <TD width="61px" height="14px">&nbsp;</TD> <TD width="61px" height="14px">&nbsp;</TD> <TD width="61px" height="14px">&nbsp;</TD> </TR> </TBODY> </TABLE> Thu, 31 Mar 2022 17:54:03 GMT https://community.qlik.com/t5/App-Development/Pivot-Table/m-p/1912689#M75229 kavirao 2022-03-31T17:54:03Z https://community.qlik.com/t5/App-Development/Pivot-Table/m-p/1919248#M75617 <P>Like below</P> <P>stdev(TOTAL &lt;<SPAN>Quarter</SPAN>&gt; aggr( sum(Xyz) , Company,Quarter))</P> Mon, 18 Apr 2022 08:27:40 GMT https://community.qlik.com/t5/App-Development/Pivot-Table/m-p/1919248#M75617 vinieme12 2022-04-18T08:27:40Z