topic Var function from Tableau to Qlikview in QlikView https://community.qlik.com/t5/QlikView/Var-function-from-Tableau-to-Qlikview/m-p/16056#M458165 <HTML><HEAD></HEAD><BODY><P>Hi, this is driving me crazy <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" />&nbsp; i've to find correspondant function of tableau variance i QV</P><P>I'm starting from this formula</P><P></P><TABLE border="1" class="jiveBorder" height="103" style="border: 1px solid rgb(0, 0, 0); width: 227px; height: 105px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>dim</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 2</STRONG></TH></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">Var(COST)/var(VALUE) </SPAN></TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">Var(COST)/var(VALUE) </SPAN></TD></TR></TBODY></TABLE><P>Who can help me, pls?</P></BODY></HTML> Thu, 10 May 2018 14:02:59 GMT canmarroig 2018-05-10T14:02:59Z Var function from Tableau to Qlikview https://community.qlik.com/t5/QlikView/Var-function-from-Tableau-to-Qlikview/m-p/16056#M458165 <HTML><HEAD></HEAD><BODY><P>Hi, this is driving me crazy <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" />&nbsp; i've to find correspondant function of tableau variance i QV</P><P>I'm starting from this formula</P><P></P><TABLE border="1" class="jiveBorder" height="103" style="border: 1px solid rgb(0, 0, 0); width: 227px; height: 105px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>dim</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 2</STRONG></TH></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">Var(COST)/var(VALUE) </SPAN></TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">Var(COST)/var(VALUE) </SPAN></TD></TR></TBODY></TABLE><P>Who can help me, pls?</P></BODY></HTML> Thu, 10 May 2018 14:02:59 GMT https://community.qlik.com/t5/QlikView/Var-function-from-Tableau-to-Qlikview/m-p/16056#M458165 canmarroig 2018-05-10T14:02:59Z Re: Var function from Tableau to Qlikview https://community.qlik.com/t5/QlikView/Var-function-from-Tableau-to-Qlikview/m-p/16057#M458166 <HTML><HEAD></HEAD><BODY><P>May be just square the Stdev function's result</P><P></P><P><STRONG>(Stdev(COST)*Stdev(COST))/(Stdev(VALUE)*Stdev(VALUE))</STRONG></P></BODY></HTML> Thu, 10 May 2018 14:04:20 GMT https://community.qlik.com/t5/QlikView/Var-function-from-Tableau-to-Qlikview/m-p/16057#M458166 sunny_talwar 2018-05-10T14:04:20Z Re: Var function from Tableau to Qlikview https://community.qlik.com/t5/QlikView/Var-function-from-Tableau-to-Qlikview/m-p/16058#M458167 <HTML><HEAD></HEAD><BODY><P>Or simplifying Sunny's Formula:</P><P></P><P><STRONG>Pow(</STRONG><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Stdev(COST),2) / <STRONG style="font-size: 13.3333px;">Pow(</STRONG><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Stdev(<STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">VALUE</STRONG>),2) </STRONG></STRONG></P></BODY></HTML> Thu, 10 May 2018 14:07:33 GMT https://community.qlik.com/t5/QlikView/Var-function-from-Tableau-to-Qlikview/m-p/16058#M458167 vkish16161 2018-05-10T14:07:33Z