topic Re: Variable manipulation in QlikView

Variable manipulation

mahendragaur — Thu, 20 Apr 2017 12:34:37 GMT

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

Re: Variable manipulation

sunny_talwar — Thu, 20 Apr 2017 12:37:10 GMT

May be like this

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

Re: Variable manipulation

mahendragaur — Thu, 20 Apr 2017 17:52:24 GMT

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 ......)))

Re: Variable manipulation

sunny_talwar — Thu, 20 Apr 2017 18:05:08 GMT

Why would you want to do that?

Re: Variable manipulation

mahendragaur — Fri, 21 Apr 2017 02:59:12 GMT

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

Re: Variable manipulation

prachisangewar — Fri, 21 Apr 2017 03:45:05 GMT

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.

Re: Variable manipulation

mahendragaur — Fri, 21 Apr 2017 10:03:23 GMT

I didn't find any attachment

Re: Variable manipulation

prachisangewar — Fri, 21 Apr 2017 10:05:18 GMT

Hi,

Attached the qvw file below.

Re: Variable manipulation

mahendragaur — Fri, 21 Apr 2017 10:14:09 GMT

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

Re: Variable manipulation

klausskalts — Fri, 21 Apr 2017 10:24:14 GMT

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

Just remember to reset INPUT-values after each reload.

Re: Variable manipulation

mahendragaur — Fri, 21 Apr 2017 12:25:13 GMT

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.

Re: Variable manipulation

klausskalts — Fri, 21 Apr 2017 12:59:59 GMT

Check this app .... !

Re: Variable manipulation

klausskalts — Fri, 21 Apr 2017 13:01:25 GMT

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

Re: Variable manipulation

klausskalts — Fri, 21 Apr 2017 13:02:15 GMT

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

Re: Variable manipulation

mahendragaur — Mon, 24 Apr 2017 07:03:57 GMT

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