Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mahendragaur
Creator
Creator

Variable manipulation

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
A20
B50
C30
D60

Current Pivot Chart-

   

NameValue
A10
B20
C3
D40
E100
F60

Expected Pivot Chart-

   

NameValue
A200
B1000
C90
D2400
E100
F60

 

14 Replies
mahendragaur
Creator
Creator
Author

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
Partner - Creator
Partner - Creator

Check this app .... ! 

 

klausskalts
Partner - Creator
Partner - Creator

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

klausskalts
Partner - Creator
Partner - Creator

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

mahendragaur
Creator
Creator
Author

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