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

[mahendragaur]

Hello Klaus,

Could you please tell me, How can I create INPUTFIELD and INPUTSUM. Because I tried but it is showing me  "Field not found" error.

[klausskalts]

Check this app .... ! 

[klausskalts]

When you hover over the Input-fields - then you can click on the triangle to change the value ...

[klausskalts]

Please note that I used INPUTAVG in the straight-able ....

[mahendragaur]

I want to get the default value as 1 for all inputfields. How can I do that?