Adding new calculated collum to table

[#1]

Hi everyone

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?

Thank you very much for your help!

[bbi_mba_76]

Hi,

load *, [sales values] * [conversion rate] as NewField;

SQL your select ...;

[#3]

in the load statement add (sales_vales * currency_rate) as new_col

load ................

....................... as new_col

SQL SELECT.......;

[#4]

Awesome!  Thanks a lot