topic Re: Problem formul with 2 variables in QlikView

Problem formul with 2 variables

inigoelv — Mon, 21 Oct 2013 20:53:15 GMT

Hello:

I have problem with the use of two variables in a formula:

1) vReception= Aggr ( Sum ({<TYPE={"Reception"}>} Quantity) MonthYear, Supplier) . Per example: 25.000 kg

2) vClaim= Aggr ( Sum ({<TYPE={"Claim"}>} Quantity) MonthYear, Supplier) . Per example: 1000 kg

When I calcul in an expression:

%=$(vClaim)/$(vReception) the result is only the first formul: 1000 kg instead of 1000/25000= 0,04

The result is like only use the first formul an forget to divide by the second.

The table is:

MonthYear	Supplier	Type	Quantity
01/2013	A	Reception	25000
01/2013	A	Claim	1000

Thanks in advance.

Tue, 18 Feb 2014 10:39:23 GMT

Do you have a solution for this issue? I have the same problem.

Tue, 18 Feb 2014 20:31:32 GMT

You need this expression in the text object ?

Tue, 18 Feb 2014 20:35:24 GMT

Use

Let vClaim and

Let vReception

to solve the problem.

maxgro — Tue, 18 Feb 2014 20:46:27 GMT

using input box with these expressions

vC = Aggr ( Sum ({<Type={"Reception"}>} Quantity), MonthYear, Supplier)

vR = Aggr ( Sum ({$<Type={"Claim"}>} Quantity), MonthYear, Supplier)

I get 0.04 for

=$(vC) / $(vR)

chiru_thota — Tue, 18 Feb 2014 21:00:14 GMT

Hi,

Use = symbol in variables .you can get that.

have a look at attached QVW.