topic Variance Column in App Development https://community.qlik.com/t5/App-Development/Variance-Column/m-p/1344586#M29746 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I am trying to work out how to create a variance column in a table. <SPAN style="font-size: 10pt;">So if you select Jan, Feb and Mar, I would like that to be compared to the Q1 Budget and display how much the spending went over or under. And if you select Apr, May, June I want that to be compared to Q2 budget and so on...</SPAN></P><P></P><P>To my untrained eyes, that seems quite complicated but I assume that it must be possible and that others have wanted to do similar things. </P><P></P><P>I have attached an app that I made for these purposes so, if possible, please can you demonstrate the solution on the app.</P><P></P><P>Thank you all very much in advance,</P><P>Alison </P></BODY></HTML> Thu, 20 Jul 2017 12:15:24 GMT 2017-07-20T12:15:24Z Variance Column https://community.qlik.com/t5/App-Development/Variance-Column/m-p/1344586#M29746 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I am trying to work out how to create a variance column in a table. <SPAN style="font-size: 10pt;">So if you select Jan, Feb and Mar, I would like that to be compared to the Q1 Budget and display how much the spending went over or under. And if you select Apr, May, June I want that to be compared to Q2 budget and so on...</SPAN></P><P></P><P>To my untrained eyes, that seems quite complicated but I assume that it must be possible and that others have wanted to do similar things. </P><P></P><P>I have attached an app that I made for these purposes so, if possible, please can you demonstrate the solution on the app.</P><P></P><P>Thank you all very much in advance,</P><P>Alison </P></BODY></HTML> Thu, 20 Jul 2017 12:15:24 GMT https://community.qlik.com/t5/App-Development/Variance-Column/m-p/1344586#M29746 2017-07-20T12:15:24Z Re: Variance Column https://community.qlik.com/t5/App-Development/Variance-Column/m-p/1344587#M29747 <HTML><HEAD></HEAD><BODY><P>Hi Allison,</P><P></P><P>I'm searching to find a solution to this same issue. Where you able to find a solution?</P><P></P><P>Thanks, Megan</P></BODY></HTML> Fri, 15 Sep 2017 14:20:43 GMT https://community.qlik.com/t5/App-Development/Variance-Column/m-p/1344587#M29747 megan_deboer 2017-09-15T14:20:43Z