Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

raghavsurya
Valued Contributor

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
Valued Contributor

reverting the changes made to "Input field"

Thanks Miguel.... it works

Regards,

Raghav

4 Replies
MVP
MVP

reverting the changes made to "Input field"

Hello Raghav,

Over your chart inputsum right click and select Restore value.

Hope that helps.

raghavsurya
Valued Contributor

reverting the changes made to "Input field"

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

MVP
MVP

reverting the changes made to "Input field"

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
Valued Contributor

reverting the changes made to "Input field"

Thanks Miguel.... it works

Regards,

Raghav

Community Browser