topic Re: Inputfield Help in QlikView

Inputfield Help

Anonymous — Fri, 29 May 2015 15:23:09 GMT

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

Re: Inputfield Help

Gysbert_Wassenaar — Fri, 29 May 2015 16:01:02 GMT

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.

Re: Inputfield Help

Anonymous — Thu, 04 Jun 2015 14:01:49 GMT

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

Re: Inputfield Help

Anonymous — Mon, 08 Jun 2015 14:58:33 GMT

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