topic Calculation on table columns in Connectivity & Data Prep https://community.qlik.com/t5/Connectivity-Data-Prep/Calculation-on-table-columns/m-p/1283450#M2645 <HTML><HEAD></HEAD><BODY><P>Hi Community</P><P></P><P>I would like to work out a ration of the column "goal" and "actual YTD" to get a progress to target type figure.</P><P></P><P>Qlik is returning a kind of null value, is there a best practice way to do this?</P><P></P><P>Goal and actual YTD are in different but associated sheets.</P><P></P><P>Thanks!</P></BODY></HTML> Mon, 27 Mar 2017 10:59:51 GMT 2017-03-27T10:59:51Z Calculation on table columns https://community.qlik.com/t5/Connectivity-Data-Prep/Calculation-on-table-columns/m-p/1283450#M2645 <HTML><HEAD></HEAD><BODY><P>Hi Community</P><P></P><P>I would like to work out a ration of the column "goal" and "actual YTD" to get a progress to target type figure.</P><P></P><P>Qlik is returning a kind of null value, is there a best practice way to do this?</P><P></P><P>Goal and actual YTD are in different but associated sheets.</P><P></P><P>Thanks!</P></BODY></HTML> Mon, 27 Mar 2017 10:59:51 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Calculation-on-table-columns/m-p/1283450#M2645 2017-03-27T10:59:51Z Re: Calculation on table columns https://community.qlik.com/t5/Connectivity-Data-Prep/Calculation-on-table-columns/m-p/1283451#M2646 <HTML><HEAD></HEAD><BODY><P>What is the expressions behind goal and actual YTD?</P></BODY></HTML> Mon, 27 Mar 2017 15:49:02 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Calculation-on-table-columns/m-p/1283451#M2646 sunny_talwar 2017-03-27T15:49:02Z Re: Calculation on table columns https://community.qlik.com/t5/Connectivity-Data-Prep/Calculation-on-table-columns/m-p/1283452#M2647 <HTML><HEAD></HEAD><BODY><P>Hi Sunny, I fixed it, thanks anyway</P></BODY></HTML> Mon, 27 Mar 2017 16:08:00 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Calculation-on-table-columns/m-p/1283452#M2647 2017-03-27T16:08:00Z