topic Multiply two fields in QlikView

Multiply two fields

alec1982 — Wed, 01 Aug 2012 20:12:45 GMT

Hi,

i have a table that laoding from a resident table.

Residenttable:

ID,

Amount

Factor

From XML Path

CalculationTable:

ID,

Amount * Factor as AmountinUSD

Resident

Residenttable

Not sure why the calculation is not workingeven the Amount field and the factor fields exisit.

Thanks,

Alec,

Re: Multiply two fields

CELAMBARASAN — Wed, 01 Aug 2012 20:18:55 GMT

Have you got any error?

Re: Multiply two fields

MayilVahanan — Wed, 01 Aug 2012 20:19:25 GMT

Its work..Try like this,

Load ID,

Only(Amount) * Only(Factor) as AmountinUSD

Resident ResidentTable

Group by ID;

Hope it helps

Re: Multiply two fields

swuehl — Wed, 01 Aug 2012 20:27:29 GMT

Can both fields be interpreted as numbers?

What is the input format of your fields Amount and Factor?

What are your default formats for currency / numbers (decimal separator and thousand separator)?

Re: Multiply two fields

CELAMBARASAN — Wed, 01 Aug 2012 20:30:31 GMT

Hi Mayil,

It doesn't calculate(results null) if ID has duplicates.I mean if ID has multiple amounts and Factor

Re: Multiply two fields

alec1982 — Wed, 01 Aug 2012 20:36:59 GMT

hi,

They are both Nrs.

Thanks,

Re: Multiply two fields

MayilVahanan — Wed, 01 Aug 2012 20:38:35 GMT

Thanks cimbu for your tips..I thought its distinct ID..

Sum(Amount) * Sum(Factor) as AmountinUsd..

Amount * Factor

If both are number format.. Suppose, Anyone contain non - numberic value means, it doesn't satisfy..Please mack sure the format..

Hope it helps

Re: Multiply two fields

alec1982 — Thu, 02 Aug 2012 13:11:36 GMT

The way I had was working but the factor field has values of 1 in most cases.

Thanks for all your help.

Alec,