Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

calculed field

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

5 Replies
its_anandrjs

In a list box write expression with go to expression and write

[sales quantity] * price

Not applicable
Author

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.

Calculated Field.png

Not applicable
Author

but the result of the multiplication in which field should be placed?

In which field should put the result?

maxgro
MVP
MVP

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]

     ......

Anonymous
Not applicable
Author

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.