topic How to find Variance ? in QlikView https://community.qlik.com/t5/QlikView/How-to-find-Variance/m-p/437204#M163080 <HTML><HEAD></HEAD><BODY><P>Given Data Table:</P><P></P><TABLE border="1" cellpadding="0" cellspacing="0" style="border: none; padding: 0 5.4pt 0 5.4pt;"><TBODY><TR><TD nowrap="nowrap" style="border: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="65"><P style="margin-bottom: .0001pt;">Date</P></TD><TD nowrap="nowrap" style="border: solid black 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="64"><P style="margin-bottom: .0001pt;">Month</P></TD><TD nowrap="nowrap" style="border: solid black 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="64"><P style="margin-bottom: .0001pt;">Amt</P></TD></TR><TR><TD nowrap="nowrap" style="border: solid black 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="65"><P style="margin-bottom: .0001pt;">1/1/2012</P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="64"><P style="margin-bottom: .0001pt;">Jan</P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="64"><P style="margin-bottom: .0001pt;">100</P></TD></TR><TR><TD nowrap="nowrap" style="border: solid black 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="65"><P style="margin-bottom: .0001pt;">2/1/2012</P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="64"><P style="margin-bottom: .0001pt;">Jan</P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="64"><P style="margin-bottom: .0001pt;">200</P></TD></TR><TR><TD nowrap="nowrap" style="border: solid black 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="65"><P style="margin-bottom: .0001pt;">15/1/2012</P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="64"><P style="margin-bottom: .0001pt;">Jan</P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="64"><P style="margin-bottom: .0001pt;">500</P></TD></TR><TR><TD nowrap="nowrap" style="border: solid black 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="65"><P style="margin-bottom: .0001pt;">31/1/2012</P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="64"><P style="margin-bottom: .0001pt;">Jan</P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="64"><P style="margin-bottom: .0001pt;">800</P></TD></TR><TR><TD nowrap="nowrap" style="border: solid black 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="65"><P style="margin-bottom: .0001pt;">1/2/2012</P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="64"><P style="margin-bottom: .0001pt;">Feb</P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="64"><P style="margin-bottom: .0001pt;">600</P></TD></TR><TR><TD nowrap="nowrap" style="border: solid black 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="65"><P style="margin-bottom: .0001pt;">5/2/2012</P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="64"><P style="margin-bottom: .0001pt;">Feb</P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="64"><P style="margin-bottom: .0001pt;">300</P></TD></TR><TR><TD nowrap="nowrap" style="border: solid black 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="65"><P style="margin-bottom: .0001pt;">10/2/2012</P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="64"><P style="margin-bottom: .0001pt;">Feb</P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="64"><P style="margin-bottom: .0001pt;">100</P></TD></TR><TR><TD nowrap="nowrap" style="border: solid black 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="65"><P style="margin-bottom: .0001pt;">28/2/2012</P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="64"><P style="margin-bottom: .0001pt;">Feb</P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="64"><P style="margin-bottom: .0001pt;">150</P></TD></TR><TR><TD nowrap="nowrap" style="border: solid black 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="65"><P style="margin-bottom: .0001pt;">1/3/2012</P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="64"><P style="margin-bottom: .0001pt;">Mar</P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="64"><P style="margin-bottom: .0001pt;">200</P></TD></TR><TR><TD nowrap="nowrap" style="border: solid black 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="65"><P style="margin-bottom: .0001pt;">5/3/2012</P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="64"><P style="margin-bottom: .0001pt;">Mar</P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="64"><P style="margin-bottom: .0001pt;">400</P></TD></TR><TR><TD nowrap="nowrap" style="border: solid black 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="65"><P style="margin-bottom: .0001pt;">15/3/2012</P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="64"><P style="margin-bottom: .0001pt;">Mar</P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="64"><P style="margin-bottom: .0001pt;">600</P></TD></TR><TR><TD nowrap="nowrap" style="border: solid black 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="65"><P style="margin-bottom: .0001pt;">31/3/2012</P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="64"><P style="margin-bottom: .0001pt;">Mar</P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="64"><P style="margin-bottom: .0001pt;">800</P></TD></TR><TR><TD nowrap="nowrap" style="border: solid black 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="65"><P style="margin-bottom: .0001pt;">1/4/2012</P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="64"><P style="margin-bottom: .0001pt;">Apr</P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="64"><P style="margin-bottom: .0001pt;">100</P></TD></TR><TR><TD nowrap="nowrap" style="border: solid black 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="65"><P style="margin-bottom: .0001pt;">5/4/2012</P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="64"><P style="margin-bottom: .0001pt;">Apr</P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="64"><P style="margin-bottom: .0001pt;">300</P></TD></TR><TR><TD nowrap="nowrap" style="border: solid black 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="65"><P style="margin-bottom: .0001pt;">20/4/2012</P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="64"><P style="margin-bottom: .0001pt;">Apr</P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="64"><P style="margin-bottom: .0001pt;">500</P></TD></TR><TR><TD nowrap="nowrap" style="border: solid black 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="65"><P style="margin-bottom: .0001pt;">30/4/2012</P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="64"><P style="margin-bottom: .0001pt;">Apr</P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="64"><P style="margin-bottom: .0001pt;">700</P></TD></TR></TBODY></TABLE><P></P><P></P><P>Required Scanario:</P><P></P><TABLE border="1" cellpadding="0" cellspacing="0" style="border: none; padding: 0 5.4pt 0 5.4pt;"><TBODY><TR><TD style="border: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="155"><P style="margin-bottom: 0.0001pt;"><STRONG>Apr</STRONG></P></TD><TD style="border: solid black 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="161"><P style="margin-bottom: 0.0001pt;"><STRONG>Mar</STRONG></P></TD><TD style="border: solid black 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="161"><P style="margin-bottom: 0.0001pt;"><STRONG>Feb</STRONG></P></TD><TD style="border: solid black 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="161"><P style="margin-bottom: 0.0001pt;"><STRONG>Jan</STRONG></P></TD></TR><TR><TD style="border: solid black 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="155"><P style="margin-bottom: 0.0001pt;">Variance=400</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="161"><P style="margin-bottom: 0.0001pt;">Variance=850</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="161"><P style="margin-bottom: 0.0001pt;">Variance=450</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="161"><P style="margin-bottom: 0.0001pt;">Variance=0</P></TD></TR><TR><TD style="border: solid black 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="155"><P style="margin-bottom: 0.0001pt;">Sum=1600</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="161"><P style="margin-bottom: 0.0001pt;">Sum=2000</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="161"><P style="margin-bottom: 0.0001pt;">Sum=1150</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="161"><P style="margin-bottom: 0.0001pt;">Sum=1600</P></TD></TR><TR><TD style="border: solid black 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="155"><P style="margin-bottom: 0.0001pt;">700</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="161"><P style="margin-bottom: 0.0001pt;">800</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="161"><P style="margin-bottom: 0.0001pt;">150</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="161"><P style="margin-bottom: 0.0001pt;">800</P></TD></TR><TR><TD style="border: solid black 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="155"><P style="margin-bottom: 0.0001pt;">500</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="161"><P style="margin-bottom: 0.0001pt;">600</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="161"><P style="margin-bottom: 0.0001pt;">100</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="161"><P style="margin-bottom: 0.0001pt;">500</P></TD></TR><TR><TD style="border: solid black 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="155"><P style="margin-bottom: 0.0001pt;">300</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="161"><P style="margin-bottom: 0.0001pt;">400</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="161"><P style="margin-bottom: 0.0001pt;">300</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="161"><P style="margin-bottom: 0.0001pt;">200</P></TD></TR><TR><TD style="border: solid black 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="155"><P style="margin-bottom: 0.0001pt;">100</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="161"><P style="margin-bottom: 0.0001pt;">200</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="161"><P style="margin-bottom: 0.0001pt;">600</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="161"><P style="margin-bottom: 0.0001pt;">100</P></TD></TR></TBODY></TABLE><P></P><P>Note: Please keep in mind that we will have to take date as a dimension</P><P></P><P>Please find attached data file as source</P></BODY></HTML> Tue, 25 Sep 2012 06:23:36 GMT 2012-09-25T06:23:36Z How to find Variance ? https://community.qlik.com/t5/QlikView/How-to-find-Variance/m-p/437204#M163080 <HTML><HEAD></HEAD><BODY><P>Given Data Table:</P><P></P><TABLE border="1" cellpadding="0" cellspacing="0" style="border: none; padding: 0 5.4pt 0 5.4pt;"><TBODY><TR><TD nowrap="nowrap" style="border: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="65"><P style="margin-bottom: .0001pt;">Date</P></TD><TD nowrap="nowrap" style="border: solid black 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="64"><P style="margin-bottom: .0001pt;">Month</P></TD><TD nowrap="nowrap" style="border: solid black 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="64"><P style="margin-bottom: .0001pt;">Amt</P></TD></TR><TR><TD nowrap="nowrap" style="border: solid black 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="65"><P style="margin-bottom: .0001pt;">1/1/2012</P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="64"><P style="margin-bottom: .0001pt;">Jan</P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="64"><P style="margin-bottom: .0001pt;">100</P></TD></TR><TR><TD nowrap="nowrap" style="border: solid black 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="65"><P style="margin-bottom: .0001pt;">2/1/2012</P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="64"><P style="margin-bottom: .0001pt;">Jan</P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="64"><P style="margin-bottom: .0001pt;">200</P></TD></TR><TR><TD nowrap="nowrap" style="border: solid black 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="65"><P style="margin-bottom: .0001pt;">15/1/2012</P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="64"><P style="margin-bottom: .0001pt;">Jan</P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="64"><P style="margin-bottom: .0001pt;">500</P></TD></TR><TR><TD nowrap="nowrap" style="border: solid black 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="65"><P style="margin-bottom: .0001pt;">31/1/2012</P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="64"><P style="margin-bottom: .0001pt;">Jan</P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="64"><P style="margin-bottom: .0001pt;">800</P></TD></TR><TR><TD nowrap="nowrap" style="border: solid black 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="65"><P style="margin-bottom: .0001pt;">1/2/2012</P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="64"><P style="margin-bottom: .0001pt;">Feb</P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="64"><P style="margin-bottom: .0001pt;">600</P></TD></TR><TR><TD nowrap="nowrap" style="border: solid black 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="65"><P style="margin-bottom: .0001pt;">5/2/2012</P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="64"><P style="margin-bottom: .0001pt;">Feb</P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="64"><P style="margin-bottom: .0001pt;">300</P></TD></TR><TR><TD nowrap="nowrap" style="border: solid black 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="65"><P style="margin-bottom: .0001pt;">10/2/2012</P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="64"><P style="margin-bottom: .0001pt;">Feb</P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="64"><P style="margin-bottom: .0001pt;">100</P></TD></TR><TR><TD nowrap="nowrap" style="border: solid black 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="65"><P style="margin-bottom: .0001pt;">28/2/2012</P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="64"><P style="margin-bottom: .0001pt;">Feb</P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="64"><P style="margin-bottom: .0001pt;">150</P></TD></TR><TR><TD nowrap="nowrap" style="border: solid black 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="65"><P style="margin-bottom: .0001pt;">1/3/2012</P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="64"><P style="margin-bottom: .0001pt;">Mar</P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="64"><P style="margin-bottom: .0001pt;">200</P></TD></TR><TR><TD nowrap="nowrap" style="border: solid black 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="65"><P style="margin-bottom: .0001pt;">5/3/2012</P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="64"><P style="margin-bottom: .0001pt;">Mar</P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="64"><P style="margin-bottom: .0001pt;">400</P></TD></TR><TR><TD nowrap="nowrap" style="border: solid black 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="65"><P style="margin-bottom: .0001pt;">15/3/2012</P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="64"><P style="margin-bottom: .0001pt;">Mar</P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="64"><P style="margin-bottom: .0001pt;">600</P></TD></TR><TR><TD nowrap="nowrap" style="border: solid black 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="65"><P style="margin-bottom: .0001pt;">31/3/2012</P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="64"><P style="margin-bottom: .0001pt;">Mar</P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="64"><P style="margin-bottom: .0001pt;">800</P></TD></TR><TR><TD nowrap="nowrap" style="border: solid black 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="65"><P style="margin-bottom: .0001pt;">1/4/2012</P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="64"><P style="margin-bottom: .0001pt;">Apr</P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="64"><P style="margin-bottom: .0001pt;">100</P></TD></TR><TR><TD nowrap="nowrap" style="border: solid black 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="65"><P style="margin-bottom: .0001pt;">5/4/2012</P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="64"><P style="margin-bottom: .0001pt;">Apr</P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="64"><P style="margin-bottom: .0001pt;">300</P></TD></TR><TR><TD nowrap="nowrap" style="border: solid black 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="65"><P style="margin-bottom: .0001pt;">20/4/2012</P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="64"><P style="margin-bottom: .0001pt;">Apr</P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="64"><P style="margin-bottom: .0001pt;">500</P></TD></TR><TR><TD nowrap="nowrap" style="border: solid black 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="65"><P style="margin-bottom: .0001pt;">30/4/2012</P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="64"><P style="margin-bottom: .0001pt;">Apr</P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="64"><P style="margin-bottom: .0001pt;">700</P></TD></TR></TBODY></TABLE><P></P><P></P><P>Required Scanario:</P><P></P><TABLE border="1" cellpadding="0" cellspacing="0" style="border: none; padding: 0 5.4pt 0 5.4pt;"><TBODY><TR><TD style="border: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="155"><P style="margin-bottom: 0.0001pt;"><STRONG>Apr</STRONG></P></TD><TD style="border: solid black 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="161"><P style="margin-bottom: 0.0001pt;"><STRONG>Mar</STRONG></P></TD><TD style="border: solid black 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="161"><P style="margin-bottom: 0.0001pt;"><STRONG>Feb</STRONG></P></TD><TD style="border: solid black 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="161"><P style="margin-bottom: 0.0001pt;"><STRONG>Jan</STRONG></P></TD></TR><TR><TD style="border: solid black 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="155"><P style="margin-bottom: 0.0001pt;">Variance=400</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="161"><P style="margin-bottom: 0.0001pt;">Variance=850</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="161"><P style="margin-bottom: 0.0001pt;">Variance=450</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="161"><P style="margin-bottom: 0.0001pt;">Variance=0</P></TD></TR><TR><TD style="border: solid black 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="155"><P style="margin-bottom: 0.0001pt;">Sum=1600</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="161"><P style="margin-bottom: 0.0001pt;">Sum=2000</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="161"><P style="margin-bottom: 0.0001pt;">Sum=1150</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="161"><P style="margin-bottom: 0.0001pt;">Sum=1600</P></TD></TR><TR><TD style="border: solid black 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="155"><P style="margin-bottom: 0.0001pt;">700</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="161"><P style="margin-bottom: 0.0001pt;">800</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="161"><P style="margin-bottom: 0.0001pt;">150</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="161"><P style="margin-bottom: 0.0001pt;">800</P></TD></TR><TR><TD style="border: solid black 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="155"><P style="margin-bottom: 0.0001pt;">500</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="161"><P style="margin-bottom: 0.0001pt;">600</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="161"><P style="margin-bottom: 0.0001pt;">100</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="161"><P style="margin-bottom: 0.0001pt;">500</P></TD></TR><TR><TD style="border: solid black 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="155"><P style="margin-bottom: 0.0001pt;">300</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="161"><P style="margin-bottom: 0.0001pt;">400</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="161"><P style="margin-bottom: 0.0001pt;">300</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="161"><P style="margin-bottom: 0.0001pt;">200</P></TD></TR><TR><TD style="border: solid black 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="155"><P style="margin-bottom: 0.0001pt;">100</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="161"><P style="margin-bottom: 0.0001pt;">200</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="161"><P style="margin-bottom: 0.0001pt;">600</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="161"><P style="margin-bottom: 0.0001pt;">100</P></TD></TR></TBODY></TABLE><P></P><P>Note: Please keep in mind that we will have to take date as a dimension</P><P></P><P>Please find attached data file as source</P></BODY></HTML> Tue, 25 Sep 2012 06:23:36 GMT https://community.qlik.com/t5/QlikView/How-to-find-Variance/m-p/437204#M163080 2012-09-25T06:23:36Z Re: How to find Variance ? https://community.qlik.com/t5/QlikView/How-to-find-Variance/m-p/437205#M163081 <HTML><HEAD></HEAD><BODY><P>If you use Sum as your first Expression:</P><P>Expression1: =Sum(Amt)</P><P>Then for caculating Variance you may use:</P><P>Expression2: =After(Column(1))-Column(1)</P><P></P><P><IMG __jive_id="22466" class="jive-image-thumbnail jive-image" onclick="" alt="VarSum.jpg" src="https://community.qlik.com/legacyfs/online/22466_VarSum.jpg" width="450" /></P></BODY></HTML> Tue, 25 Sep 2012 12:40:31 GMT https://community.qlik.com/t5/QlikView/How-to-find-Variance/m-p/437205#M163081 2012-09-25T12:40:31Z