Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Hi,
load *, [sales values] * [conversion rate] as NewField;
SQL your select ...;
in the load statement add (sales_vales * currency_rate) as new_col
load ................
....................... as new_col
SQL SELECT.......;
Awesome! Thanks a lot