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-
Current Pivot Chart-
Expected Pivot Chart-
May be like this
Sum(If(Variable > 0, Value * Variable, Value))
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 ......)))
Why would you want to do that?
On the fly user wants to enter values and then it should multiply with the expected output which i mentioned.
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.
I didn't find any attachment
Attached the qvw file below.
Any other solution? because I have to do it for 40-50 different variables and I already have so much calculation in expression.
I would use INPUTFIELD and INPUTSUM instead of variables - it's much more flexible.
Just remember to reset INPUT-values after each reload.
Could you please tell me, How can I create INPUTFIELD and INPUTSUM. Because I tried but it is showing me "Field not found" error.
Check this app .... !
When you hover over the Input-fields - then you can click on the triangle to change the value ...
Please note that I used INPUTAVG in the straight-able ....
I want to get the default value as 1 for all inputfields. How can I do that?
Retrieving data ...