topic Equivalent Excel Stdevp in Qlikview in QlikView https://community.qlik.com/t5/QlikView/Equivalent-Excel-Stdevp-in-Qlikview/m-p/1187249#M384014 <HTML><HEAD></HEAD><BODY><P>Hi</P><P style="margin-bottom: 0.0001pt;">Is there any equivalent function like excel <SPAN style="font-size: 12.0pt; font-family: 'Courier New'; color: blue;"><STRONG>Stdevp</STRONG></SPAN>?</P><P style="margin-bottom: 0.0001pt;">I found some solutions in this forum like:</P><P style="margin-bottom: 0.0001pt;"></P><P style="margin-bottom: 0.0001pt;"><SPAN style="color: black; font-size: 10pt; font-family: 'Courier New';">=</SPAN><SPAN style="font-size: 10pt;"><SPAN style="font-family: 'Courier New'; color: blue;">sqrt</SPAN><SPAN style="font-family: 'Courier New'; color: black;">(</SPAN><SPAN style="font-family: 'Courier New'; color: blue;">sum</SPAN><SPAN style="font-family: 'Courier New'; color: black;">(</SPAN><SPAN style="font-family: 'Courier New'; color: blue;">aggr</SPAN><SPAN style="font-family: 'Courier New'; color: black;">(</SPAN><SPAN style="font-family: 'Courier New'; color: blue;">pow</SPAN><SPAN style="font-family: 'Courier New'; color: black;">(</SPAN><SPAN style="font-family: 'Courier New'; color: blue;">sum</SPAN><SPAN style="font-family: 'Courier New'; color: black;">(</SPAN><SPAN style="font-family: 'Courier New'; color: maroon;">Field</SPAN><SPAN style="font-family: 'Courier New'; color: black;">)<BR /> -<BR /> </SPAN><SPAN style="font-family: 'Courier New'; color: blue;">sum</SPAN><SPAN style="font-family: 'Courier New'; color: black;">(</SPAN><SPAN style="font-family: 'Courier New'; color: blue;">total</SPAN> <SPAN style="font-family: 'Courier New'; color: maroon;">Field</SPAN><SPAN style="font-family: 'Courier New'; color: black;">)/</SPAN><SPAN style="font-family: 'Courier New'; color: blue;">count</SPAN><SPAN style="font-family: 'Courier New'; color: black;">(</SPAN><SPAN style="font-family: 'Courier New'; color: blue;">total</SPAN> <SPAN style="font-family: 'Courier New'; color: blue;">distinct</SPAN> <SPAN style="font-family: 'Courier New'; color: maroon;">Date</SPAN><SPAN style="font-family: 'Courier New'; color: black;">),2),</SPAN><SPAN style="font-family: 'Courier New'; color: maroon;">Date</SPAN><SPAN style="font-family: 'Courier New'; color: black;">))/</SPAN><SPAN style="font-family: 'Courier New'; color: blue;">Count</SPAN><SPAN style="font-family: 'Courier New'; color: black;">(</SPAN><SPAN style="font-family: 'Courier New'; color: blue;">TOTAL</SPAN> <SPAN style="font-family: 'Courier New'; color: blue;">DISTINCT</SPAN> <SPAN style="font-family: 'Courier New'; color: maroon;">Date</SPAN></SPAN><SPAN style="font-size: 12.0pt; font-family: 'Courier New'; color: black;"><SPAN style="font-size: 10pt;">))</SPAN> </SPAN></P><P style="margin-bottom: 0.0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Courier New'; color: black;"><BR /></SPAN></P><P style="margin-bottom: 0.0001pt;"><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: black;">but it does not work accurately </SPAN></P><P><SPAN style="color: #000000; font-family: 'Courier New'; font-size: 13.3333px;">Thanks a lot</SPAN></P></BODY></HTML> Sun, 18 Sep 2016 07:23:11 GMT Anonymous 2016-09-18T07:23:11Z Equivalent Excel Stdevp in Qlikview https://community.qlik.com/t5/QlikView/Equivalent-Excel-Stdevp-in-Qlikview/m-p/1187249#M384014 <HTML><HEAD></HEAD><BODY><P>Hi</P><P style="margin-bottom: 0.0001pt;">Is there any equivalent function like excel <SPAN style="font-size: 12.0pt; font-family: 'Courier New'; color: blue;"><STRONG>Stdevp</STRONG></SPAN>?</P><P style="margin-bottom: 0.0001pt;">I found some solutions in this forum like:</P><P style="margin-bottom: 0.0001pt;"></P><P style="margin-bottom: 0.0001pt;"><SPAN style="color: black; font-size: 10pt; font-family: 'Courier New';">=</SPAN><SPAN style="font-size: 10pt;"><SPAN style="font-family: 'Courier New'; color: blue;">sqrt</SPAN><SPAN style="font-family: 'Courier New'; color: black;">(</SPAN><SPAN style="font-family: 'Courier New'; color: blue;">sum</SPAN><SPAN style="font-family: 'Courier New'; color: black;">(</SPAN><SPAN style="font-family: 'Courier New'; color: blue;">aggr</SPAN><SPAN style="font-family: 'Courier New'; color: black;">(</SPAN><SPAN style="font-family: 'Courier New'; color: blue;">pow</SPAN><SPAN style="font-family: 'Courier New'; color: black;">(</SPAN><SPAN style="font-family: 'Courier New'; color: blue;">sum</SPAN><SPAN style="font-family: 'Courier New'; color: black;">(</SPAN><SPAN style="font-family: 'Courier New'; color: maroon;">Field</SPAN><SPAN style="font-family: 'Courier New'; color: black;">)<BR /> -<BR /> </SPAN><SPAN style="font-family: 'Courier New'; color: blue;">sum</SPAN><SPAN style="font-family: 'Courier New'; color: black;">(</SPAN><SPAN style="font-family: 'Courier New'; color: blue;">total</SPAN> <SPAN style="font-family: 'Courier New'; color: maroon;">Field</SPAN><SPAN style="font-family: 'Courier New'; color: black;">)/</SPAN><SPAN style="font-family: 'Courier New'; color: blue;">count</SPAN><SPAN style="font-family: 'Courier New'; color: black;">(</SPAN><SPAN style="font-family: 'Courier New'; color: blue;">total</SPAN> <SPAN style="font-family: 'Courier New'; color: blue;">distinct</SPAN> <SPAN style="font-family: 'Courier New'; color: maroon;">Date</SPAN><SPAN style="font-family: 'Courier New'; color: black;">),2),</SPAN><SPAN style="font-family: 'Courier New'; color: maroon;">Date</SPAN><SPAN style="font-family: 'Courier New'; color: black;">))/</SPAN><SPAN style="font-family: 'Courier New'; color: blue;">Count</SPAN><SPAN style="font-family: 'Courier New'; color: black;">(</SPAN><SPAN style="font-family: 'Courier New'; color: blue;">TOTAL</SPAN> <SPAN style="font-family: 'Courier New'; color: blue;">DISTINCT</SPAN> <SPAN style="font-family: 'Courier New'; color: maroon;">Date</SPAN></SPAN><SPAN style="font-size: 12.0pt; font-family: 'Courier New'; color: black;"><SPAN style="font-size: 10pt;">))</SPAN> </SPAN></P><P style="margin-bottom: 0.0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Courier New'; color: black;"><BR /></SPAN></P><P style="margin-bottom: 0.0001pt;"><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: black;">but it does not work accurately </SPAN></P><P><SPAN style="color: #000000; font-family: 'Courier New'; font-size: 13.3333px;">Thanks a lot</SPAN></P></BODY></HTML> Sun, 18 Sep 2016 07:23:11 GMT https://community.qlik.com/t5/QlikView/Equivalent-Excel-Stdevp-in-Qlikview/m-p/1187249#M384014 Anonymous 2016-09-18T07:23:11Z Re: Equivalent Excel Stdevp in Qlikview https://community.qlik.com/t5/QlikView/Equivalent-Excel-Stdevp-in-Qlikview/m-p/1187250#M384015 <HTML><HEAD></HEAD><BODY><P>Have a look at my answer here</P><P><A href="https://community.qlik.com/message/793753">Re: STDEV.S function in qlikview</A></P></BODY></HTML> Sun, 18 Sep 2016 20:43:41 GMT https://community.qlik.com/t5/QlikView/Equivalent-Excel-Stdevp-in-Qlikview/m-p/1187250#M384015 swuehl 2016-09-18T20:43:41Z Re: Equivalent Excel Stdevp in Qlikview https://community.qlik.com/t5/QlikView/Equivalent-Excel-Stdevp-in-Qlikview/m-p/1187251#M384016 <HTML><HEAD></HEAD><BODY><P>Yes. Thank you. Works good.</P></BODY></HTML> Mon, 19 Sep 2016 03:24:47 GMT https://community.qlik.com/t5/QlikView/Equivalent-Excel-Stdevp-in-Qlikview/m-p/1187251#M384016 Anonymous 2016-09-19T03:24:47Z