topic Re: Input Box - Not able to enter value in input box in Qlikview in QlikView

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

KishoreSuriF — Thu, 08 Feb 2024 17:39:06 GMT

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.

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

henrikalmen — Fri, 09 Feb 2024 08:44:54 GMT

When you click on the value in the input box QlikView will display the expression, since the variable is holding an expression. If you enter for example 250 as a value, the expression will be repolaced with that value.

What would you like to have happened in the input box?= What is it that you want to achieve?

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

KishoreSuriF — Fri, 09 Feb 2024 08:48:12 GMT

Thanks for reply.

When I click on the input box field , it not allowing to enter any value immediately shows the expression

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

henrikalmen — Fri, 09 Feb 2024 08:57:35 GMT

The expression will be displayed yes, but then you should be able to replace the expression by entering a new value.

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

KishoreSuriF — Fri, 09 Feb 2024 09:29:55 GMT

It’s not allowing to enter the number.

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

henrikalmen — Fri, 09 Feb 2024 09:45:10 GMT

How is it not allowing? Is it impossible to enter anything at all or does the value revert back to the expression when pressing enter? Have you checked the settings for the input box on the Constraints tab in the input box properties?

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

KishoreSuriF — Fri, 09 Feb 2024 12:51:28 GMT

It’s not allowing to enter value. When we click on the box , it shows the used expression and we press enter it shows the same value generated by expression.

Yes, checked the properties but no use of them in our case.

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

henrikalmen — Fri, 09 Feb 2024 13:02:13 GMT

Maybe I misunderstand, but you say "we press enter". Are you first entering your new value and then pressing enter? Because that should work. Have you tried checking "Enable Edit Expression Dialog" in properties for the input box, and then used the expression editor to enter a new value?

If none of this works, and you don't have any input constraints in the properties of the input box I don't know what's going on. Have you tried creating a new input box with the same variable just to try with another object? Also try a new input box with a new variable just to make sure that works.

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

KishoreSuriF — Fri, 09 Feb 2024 13:16:16 GMT

Thanks for your quick response.

Enter means by clicking on the input box (to enter some value) it shows the used expression.
moving cursor from that place to another and then either click mouse or enter in keyboard , it shows the previous value

Yes, created new input box with and without using any expression

without expression, it allowed

of course , it did all checks in the properties of input box, but I’m not succeeded

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

henrikalmen — Fri, 09 Feb 2024 13:19:17 GMT

Sounds strange indeed. Unfortunately I'm out of ideas now.

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

KishoreSuriF — Fri, 09 Feb 2024 13:20:35 GMT

Thanks for your support and suggestions

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

marcus_sommer — Fri, 09 Feb 2024 15:11:04 GMT

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.

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

KishoreSuriF — Wed, 14 Feb 2024 10:02:34 GMT

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

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

marcus_sommer — Wed, 14 Feb 2024 10:28:15 GMT

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).

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

KishoreSuriF — Wed, 14 Feb 2024 10:30:15 GMT

Thanks again for the suggestion, will try it

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

vincent_ardiet_ — Wed, 14 Feb 2024 10:35:30 GMT

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.