Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
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.
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?