Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
My first'm using QlikView
in a list box I want to add a calculated field.
import sales = sales quantity * price.
how should I do?
thank you
In a list box write expression with go to expression and write
[sales quantity] * price
Hi,
Create a list box, go to General Sheet, find a Field Combo Box and select "Expression" at the end of the list finally tip your formula [sales quantity] * price and if you want specify a title for this calculated field.
Best Regards.
but the result of the multiplication in which field should be placed?
In which field should put the result?
the result is only displayed in the listbox
there isn't a new field with [sales quantity] * price
if you want a new field for [sales quantity] * price you should add it in the load script; assuming you already load sales quantity and price from the same table, something similar to
load
.....
[sales quantity],
price,
......,
[sales quantity] * price as [new field]
......
Result values are what you are seeing in list box...
if you want to rename it do it in caption. If you want this resultant field to be used somewhere instead of list box, do it dirrectly in that object or better do this multiplication in load script.