Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Thanks Gysbert! Will check it out shortly and let you know.
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