topic Re: Varince Calculation in QlikView https://community.qlik.com/t5/QlikView/Varince-Calculation/m-p/562518#M209937 <HTML><HEAD></HEAD><BODY><P>I used the before function in the pivot table to calculate the variance.&nbsp; </P><P></P><P>You can also use above it you pivot the table or use a straight table.&nbsp; Search interchart functions to see how you can reference other values in a chart.</P><P></P><P>Another way is to use previous() or peek() in the load statement ordering the data by date.</P><P></P><P></P><P>I attached an example for the first approach.</P><P></P><P>Wade</P></BODY></HTML> Tue, 06 Aug 2013 20:08:19 GMT wms_manis 2013-08-06T20:08:19Z Varince Calculation https://community.qlik.com/t5/QlikView/Varince-Calculation/m-p/562517#M209936 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have to calculate variance as follows with eg data.</P><P></P><P>Date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; vlues</P><P></P><P>10-oct&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100 eg</P><P>18-oct&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 190</P><P>25-oct&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 500</P><P>28-oct&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 300</P><P>5-sept&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 900</P><P>10th-nov.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 300&nbsp; </P><P></P><P>I took this date filed in Pivot table like this as a dimension and i have to add one field like varince and i took 1 in expression and i need script for calcaultion of varince between eg 5-sept and 10th nov</P><P></P><P>Date&nbsp; 10-oct&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 18-oct&nbsp;&nbsp;&nbsp; 25-oct&nbsp;&nbsp;&nbsp; 28-oct&nbsp;&nbsp;&nbsp;&nbsp; 5-sept&nbsp;&nbsp;&nbsp; 10th-nov.&nbsp;&nbsp;&nbsp; varince</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 190&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 500&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 300&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 900&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 300&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -600(Expected value)</P><P></P><P>If your giving dynamic formula or static formula its help me.</P><P></P><P>Thanks,</P><P>Ravi Teja</P></BODY></HTML> Tue, 06 Aug 2013 18:30:39 GMT https://community.qlik.com/t5/QlikView/Varince-Calculation/m-p/562517#M209936 2013-08-06T18:30:39Z Re: Varince Calculation https://community.qlik.com/t5/QlikView/Varince-Calculation/m-p/562518#M209937 <HTML><HEAD></HEAD><BODY><P>I used the before function in the pivot table to calculate the variance.&nbsp; </P><P></P><P>You can also use above it you pivot the table or use a straight table.&nbsp; Search interchart functions to see how you can reference other values in a chart.</P><P></P><P>Another way is to use previous() or peek() in the load statement ordering the data by date.</P><P></P><P></P><P>I attached an example for the first approach.</P><P></P><P>Wade</P></BODY></HTML> Tue, 06 Aug 2013 20:08:19 GMT https://community.qlik.com/t5/QlikView/Varince-Calculation/m-p/562518#M209937 wms_manis 2013-08-06T20:08:19Z