topic Re: calculed field in QlikView

calculed field

Mon, 14 Jul 2014 17:16:32 GMT

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

Re: calculed field

its_anandrjs — Mon, 14 Jul 2014 17:19:32 GMT

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

[sales quantity] * price

Re: calculed field

Mon, 14 Jul 2014 17:30:38 GMT

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.

Re: calculed field

Tue, 15 Jul 2014 16:02:37 GMT

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

In which field should put the result?

Re: calculed field

maxgro — Tue, 15 Jul 2014 16:15:31 GMT

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]

......

Re: calculed field

Anonymous — Tue, 15 Jul 2014 16:23:37 GMT

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.