Variable manipulation

[mahendragaur]

Hello,

I want to get the final output based on multiplication of variables and a column(Value) of a pivot in QlikView. Below is my requirement-

Variables-

Variables
A	20
B	50
C	30
D	60

Current Pivot Chart-

Name	Value
A	10
B	20
C	3
D	40
E	100
F	60

Expected Pivot Chart-

Name	Value
A	200
B	1000
C	90
D	2400
E	100
F	60

[sunny_talwar]

May be like this

Sum(If(Variable > 0, Value * Variable, Value))

[mahendragaur]

I think we have to check for every name i.e. sum(if(Name='A', Value*A,if(Name='B',Value*B and so on ......)))

[sunny_talwar]

Why would you want to do that?

[mahendragaur]

On the fly user wants to enter values and then it should multiply with the expected output which i mentioned.

[prachisangewar]

Hi,

Do you have Fixed number of Name values ? i.e you want to multiply only the four Name values with the variables?

If yes , attached is the solution.

[mahendragaur]

I didn't find any attachment

[prachisangewar]

Hi,

Attached the qvw file below.

[mahendragaur]

Any other solution? because I have to do it for 40-50 different variables and I already have so much calculation in expression.

[klausskalts]

I would use INPUTFIELD and INPUTSUM instead of variables - it's much more flexible.

Just remember to reset INPUT-values after each reload.