Operations with variables

[#1]

The problem is this: mathematical operations between variables do not work well !

This apparently ! In fact you must format the formula to get a correct result ( IS A BUG ???)

This not Work:

=($(v_Saldo) / $(v_Saldo_ap_1_mobile))-1

This Work (!!!!)

=(

$(v_Saldo) / $(v_Saldo_ap_1_mobile)

)-1

Does anyone know?

Adriano

[manishkumar75]

Both expressions works fine for me. I am using QlikView 9.0 SR4

[jonathandienst]

You should not need to do this.

What are the values in the variables when you try the expression?

Jonathan

[brenner_martina]

Hi,

maybe you have to use the variables without $(), if variables are numeric, their behaviour is like fields

=(v_Saldo / v_Saldo_ap_1_mobile)-1

[#5]

Hello.

Unfortunately the problem persists even without using variables $

[#6]

Hi Jonathan

The values are:

$(v_Saldo) = -7630554,26

$(v_Saldo_ap_1_mobile) = -1242752,57

Adriano

[#7]

I am using QlikView 9.0 SR5 (.....)

[jonathandienst]

The macro expansion version doesn't work for me either (I don't know why), but the simple one

(v_Saldo / v_Saldo_ap_1_mobile)-1

does. See the attached qvw.

[jonathandienst]

Forgot to say, I am also using SR5.

[#10]

The problem is exactly that:

If you enter multiple level ad parenthesis, the formula is not calculated.

If they want to keep multiple levels of parentheses, it is necessary to "wrap" (CR) at every level of brackets.

I think this is a bug !!!

Councils write to technical support?

Thanks. Adriano