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: 
raghavsurya
Partner - Specialist
Partner - Specialist

reverting the changes made to "Input field"

Hi All,

We are currently using input fields in a straight line table for calculating the valuation of a company. The various components are like Revenue, Profit before Depreciation and Interest, Profit after tax etc. The users need a input field to change the multiple of these component to arrive at value. The below example will explain the situation

Component Amount Multiple Value

Revenue 20000 2 40000

Profit before dep 8000 3 24000

Profit after tax 6000 2.5 15000

The filed "Multiple" is a input field where the user will be able change the mulitple to arrive at a new value. Also, the users need a button to revert the changes made to mulitples to revert back to original multiple of 2, 3, 2.5 for various components.

Can anyone suggest how to handle this situation.

Regards,

Raghav

1 Solution

Accepted Solutions
raghavsurya
Partner - Specialist
Partner - Specialist
Author

Thanks Miguel.... it works

Regards,

Raghav

View solution in original post

4 Replies
Miguel_Angel_Baeyens

Hello Raghav,

Over your chart inputsum right click and select Restore value.

Hope that helps.

raghavsurya
Partner - Specialist
Partner - Specialist
Author

Hi Miguel,

Thanks for your reply. Can you please suggest how we can do using a button. The user need a button to handle this revert activity.

Regards,

Raghav

Miguel_Angel_Baeyens

Hello Raghav,

Use the following code

Sub RestoreValues set c = ActiveDocument.GetSheetObject("CH01") c.ResetInputFieldValues 0, 1, 5 '' 0 means all values, 1, means first row, 5 means fifth columnEnd Sub


Hope that helps

raghavsurya
Partner - Specialist
Partner - Specialist
Author

Thanks Miguel.... it works

Regards,

Raghav