topic Calculating daily float variance. in QlikView https://community.qlik.com/t5/QlikView/Calculating-daily-float-variance/m-p/641200#M234894 <HTML><HEAD></HEAD><BODY><P>Good Day.</P><P>I am hoping someone can assist with a way of obtaing a "Float Variance". This is the difference between today's Opening Float less yesterday's Closing Float. The attached qvw has a simple Fact table as well a a Daily1 table which is where I have tried using the expression "sum(opening_float - previous(closing_float)" to create the Float Variance value.</P><P></P><P>In the Fact1 chart I am using the expression "sum(opening_float - above([Closing Float])" to prove my variance, but in the solution this cannot work because when I select business day 2374, the variance disappears.</P><P></P><P>Ideally I need to select a day, 2347, and it should return the opening, closing and variance values for the day. The final solution will have a dash with a textbox showing the values.</P><P></P><P>I appreciate your assistance. Thank you in advance - John</P></BODY></HTML> Wed, 21 May 2014 07:49:17 GMT johngouws 2014-05-21T07:49:17Z Calculating daily float variance. https://community.qlik.com/t5/QlikView/Calculating-daily-float-variance/m-p/641200#M234894 <HTML><HEAD></HEAD><BODY><P>Good Day.</P><P>I am hoping someone can assist with a way of obtaing a "Float Variance". This is the difference between today's Opening Float less yesterday's Closing Float. The attached qvw has a simple Fact table as well a a Daily1 table which is where I have tried using the expression "sum(opening_float - previous(closing_float)" to create the Float Variance value.</P><P></P><P>In the Fact1 chart I am using the expression "sum(opening_float - above([Closing Float])" to prove my variance, but in the solution this cannot work because when I select business day 2374, the variance disappears.</P><P></P><P>Ideally I need to select a day, 2347, and it should return the opening, closing and variance values for the day. The final solution will have a dash with a textbox showing the values.</P><P></P><P>I appreciate your assistance. Thank you in advance - John</P></BODY></HTML> Wed, 21 May 2014 07:49:17 GMT https://community.qlik.com/t5/QlikView/Calculating-daily-float-variance/m-p/641200#M234894 johngouws 2014-05-21T07:49:17Z Re: Calculating daily float variance. https://community.qlik.com/t5/QlikView/Calculating-daily-float-variance/m-p/641201#M234895 <HTML><HEAD></HEAD><BODY><P>Hi All.</P><P></P><P>No worries. I found where I was going wrong and my problem is resolved.</P><P></P><P>John </P></BODY></HTML> Sat, 24 May 2014 13:33:11 GMT https://community.qlik.com/t5/QlikView/Calculating-daily-float-variance/m-p/641201#M234895 johngouws 2014-05-24T13:33:11Z