Input Box - Not able to enter value in input box in Qlikview

[KishoreSuriF]

Hi All,

As per our requirement  we are using a variable vMin in the Input box.

This vMin variable is defined with an expression =floor(rangemax(Min({<Currency=P({$}Currency),$(vPrice)={">0"}>}$(vPrice)*[Exchange Rate]),10000),1000)

Based on any selections , the vMin value is changing , but its not allowing to enter any value in this Input box 

When we click on the Input box to enter some value, it is showing the above expression as attachment.

Please help me to understand that can we enter any value in this Input box even it contains some expression 

Else it doesn't allows us to enter any value.

If it not allows any value that's ok, but it never show the expression as like in the attachment when we click on the input box.

[KishoreSuriF]

Thanks for your support and suggestions 

[marcus_sommer]

In general the overwriting of a variable-content should be working. Therefore take again a closer look on the input-box settings if there are really no restrictions like allowing only defined values or being just read-only.

Further take a look if there are anywhere other input-boxes in the application which also contain this variable. I'm not absolutely sure but I think all respectively most of these settings belong to the variable itself and not to the input-box - which may cause a conflict if a certain setting should get a second and different value.

Another check may go to the sheet and document security settings which may prevent that object-properties are changed.

Beside this I'm not sure that overwriting a variable-expression is expedient because you will loose the expression - you couldn't revert this step without re-creating it manually or per copy & paste from any backup respectively you may need a reload in the case this variable was created in the script. Personally I would use another variable which defines the second-value of the rangemax() or you wrap the variable-expression with further rangemax/rangemin() and/or alt() to react to possible values of the second variable. 

[KishoreSuriF]

Sorry, I didn’t find any solution to fix this.

[marcus_sommer]

For your current task you may not need this overwrite if you considers the suggestions from my last paragraph.

In regard to the technically aspects of being able to change this property I suggest to create a new variable with this content and a new input-box (no copy & paste - everything new and without touching further properties) and checking the behaviour again.

If this didn't work create a new application with just a few inline dummy-data and create there such variable-expression (it mustn't be the same expression - just a similar rangemax() would fulfill the purpose) + input-box. It should prove that the general approach is applicable and if it means that any specific feature prevents the intended working in the origin application. In this case just go again and more carefully through the other above suggested hints and being aware that objects might be hidden anywhere and/or the variables are included in bookmarks and/or this variable or the included variable are part of any locked calculation and/or within any section access logic or ... Probably nothing what you will find in 5 minutes else it may take ... Quite helpful in regard in a process of elimination may also be to remove all other sheets and all other objects, bookmarks, variables, groups, trigger ... (of course after ensuring to have a BACKUP).

[KishoreSuriF]

Thanks again for the suggestion, will try it 

[vincent_ardiet_]

Or you have maybe triggers that are putting the expression back?
Like @marcus_sommer says, you can user other variables. We have a kind a similar case, we have put a button to let users select default/pre-defined values, or customized one. In this case you can show/hide the input boxes and decide in your expression which values have to be took in account.