topic Can I reload a table performing a calculation on 2 fields? in QlikView

Can I reload a table performing a calculation on 2 fields?

tomdabek — Fri, 01 Dec 2017 15:52:05 GMT

Once a qvw is loaded & populated with all the data can i manipulate the tables after the load?

Lets say i have a .qvw file with the table called SALES

SALES contains two fields, quantity and price

Can i add a script element that will 'reload' SALES and create a new field called revenue where revenue = quantity * price ?

Seems simple but i cannot figure this out.

Thank you

Anonymous — Fri, 01 Dec 2017 15:54:06 GMT

noconcatenate

LOAD *, quantity * price as revenue resident SALES;

drop table SALES;

Anonymous — Fri, 01 Dec 2017 15:56:04 GMT

alternatively use preceeding load:

LOAD *, quantity * price as revenue;

SALES:

LOAD ...;