Inputfield Help

[Anonymous]

Hi All,

I have an inputfield for forecasting where I set  to equal to [Total].  When I hover my

mouse to this UserInputAmt field, it has current value where I can update to my desire amount. 

For instance, if the field have 1,000, it will be easy to update this field with a positive or

negative values.  However, if I have a bigger values with decimals, it will be harder to do the

updates if I want to increase or decrease by 550. For Example:  1,234,896.72.

Can this be done in qlikview where I can have the input field ([Total]) to display as zero and still

maintain the original value after I made the input?

For example:
Field have 1,000.00
Want Input Field ([Total]) to display as ‘0’
After I made an update with +500, I want Field value to show 1,500.00

INPUTFIELD UserInputAmt;

[Total] as UserInputAmt,

=InputSum(UserInputAmt,'*')

Any input will be greatly appreciated!. Thanks

Frankie

[Gysbert_Wassenaar]

You can create a bookmark that contains the original input field values. You have to create that bookmark before you change any values in the inputfield. Make sure to enable the option Include Input Field Values. Whenever you want to see the original values you can restore that bookmark.

[Anonymous]

Thanks Gysbert!  Will check it out shortly and let you know.

[Anonymous]

Hi Gysbert,

Bookmark didn’t help what I’m looking for. I want my input
field (Input #2) to display zero. After I made the input, I want my underlying
data (Issuer Details) to distribute proportionally like Input #1 (8,
12,16,24,40).

For example, I inputted +100 to ‘Proceeds’ for Input #1 and Input
#2 both have different results in ‘Issuer Details’ and IRR.  Please note Input #1 is correct, I just want Input
#2 to produce the same result. I wasn’t sure if this is doable or not within
qlikview. Attached is my sample QVW for reference.  Please help if you have time.

Many Thanks,

Frankie