topic Re: Adding new calculated collum to table in QlikView https://community.qlik.com/t5/QlikView/Adding-new-calculated-collum-to-table/m-p/640343#M677629 <HTML><HEAD></HEAD><BODY><P>in the load statement add (sales_vales * currency_rate) as new_col</P><P></P><P>load ................</P><P>....................... as new_col</P><P>SQL SELECT.......;</P></BODY></HTML> Thu, 05 Jun 2014 09:51:30 GMT 2014-06-05T09:51:30Z Adding new calculated collum to table https://community.qlik.com/t5/QlikView/Adding-new-calculated-collum-to-table/m-p/640341#M677627 <HTML><HEAD></HEAD><BODY><P>Hi everyone</P><P></P><P>I am loading data tables from an sql database into qlikview. I have a table containing a collum with "sales values" and one with with the "conversion rate" for the currency. I would like to create a "new collum" containing the calculated values sales values * currency rate. How would I have to script this?</P><P></P><P>Thank you very much for your help!</P></BODY></HTML> Thu, 05 Jun 2014 09:47:45 GMT https://community.qlik.com/t5/QlikView/Adding-new-calculated-collum-to-table/m-p/640341#M677627 2014-06-05T09:47:45Z Re: Adding new calculated collum to table https://community.qlik.com/t5/QlikView/Adding-new-calculated-collum-to-table/m-p/640342#M677628 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P> load *, [sales values] * [conversion rate] as NewField;</P><P>SQL your select ...;</P></BODY></HTML> Thu, 05 Jun 2014 09:50:21 GMT https://community.qlik.com/t5/QlikView/Adding-new-calculated-collum-to-table/m-p/640342#M677628 bbi_mba_76 2014-06-05T09:50:21Z Re: Adding new calculated collum to table https://community.qlik.com/t5/QlikView/Adding-new-calculated-collum-to-table/m-p/640343#M677629 <HTML><HEAD></HEAD><BODY><P>in the load statement add (sales_vales * currency_rate) as new_col</P><P></P><P>load ................</P><P>....................... as new_col</P><P>SQL SELECT.......;</P></BODY></HTML> Thu, 05 Jun 2014 09:51:30 GMT https://community.qlik.com/t5/QlikView/Adding-new-calculated-collum-to-table/m-p/640343#M677629 2014-06-05T09:51:30Z Re: Adding new calculated collum to table https://community.qlik.com/t5/QlikView/Adding-new-calculated-collum-to-table/m-p/640344#M677630 <HTML><HEAD></HEAD><BODY><P>Awesome!&nbsp; Thanks a lot <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 05 Jun 2014 11:17:34 GMT https://community.qlik.com/t5/QlikView/Adding-new-calculated-collum-to-table/m-p/640344#M677630 2014-06-05T11:17:34Z