topic Re: Format Issues with INPUTFIELD in QlikView

Format Issues with INPUTFIELD

venkat_thota — Sat, 16 Nov 2024 21:39:51 GMT

I have a straight table with one column declared as Input field. Its working good as I tested. When I enter decimal numbers it takes them as %. For example, if I give 0.35 then it takes 35%, if I give 0.6 then it takes 60%. So far so good.

For some users, the InputField column acting weird, its not taking decimals, its taking integers and doing the %. Lets take same examples, if user gives 0.35 it considers 0% rather than 35% and If user enters 35 then its taking 35%. Similarly if user enter 0.6 then it considers as 1% and user enter 60 then its considering 60%.

Not sure why this is happening. Are these browser dependent? Browser settings play a role here or machine settings play a role here?

Re: Format Issues with INPUTFIELD

marcus_sommer — Fri, 04 Jan 2019 13:27:05 GMT

It's just an idea that the region-settings from the OS or user in regard to the decimal-delimiter might be different. If the cause is not easy to find it might be an alternatively to adjust the logic to integers and to devide the appropriate results with 100.

- Marcus

Re: Format Issues with INPUTFIELD

venkat_thota — Fri, 04 Jan 2019 15:37:47 GMT

Thank you Marcus for your reply.

It shouldn't be browser dependent as it always connects to server.

I was thinking about the alternative you mentioned, if I can't resolve I will go with this route. Only problem is user should know that its percentage field. If I ask them to enter integers they may be confuse.

Re: Format Issues with INPUTFIELD

marcus_sommer — Fri, 04 Jan 2019 16:11:37 GMT

I'm not sure that there is nothing within the communication between the browser and the server which might adjust the input-values like special-chars as " are usually replaced with " or they might be just removed. In your case this might happens if the user enters 0,35 instead of 0.35 - just ask the users how they enter the values exactly and what happens if they change the delimiter-char.

- Marcus

Re: Format Issues with INPUTFIELD

venkat_thota — Mon, 07 Jan 2019 16:00:58 GMT

No, user entered in front of me and she entered correctly as 0.35.

Re: Format Issues with INPUTFIELD

marcus_sommer — Tue, 08 Jan 2019 06:18:10 GMT

Which browser (-release) is in use - maybe a change might help.

- Marcus

Re: Format Issues with INPUTFIELD

venkat_thota — Wed, 09 Jan 2019 20:53:35 GMT

Browser is IE 11 and is same for all users.

Re: Format Issues with INPUTFIELD

marcus_sommer — Thu, 10 Jan 2019 06:22:14 GMT

IE Plugin or AJAX client?

Re: Format Issues with INPUTFIELD

venkat_thota — Thu, 10 Jan 2019 17:36:16 GMT

Its AJAX client only.

Re: Format Issues with INPUTFIELD

marcus_sommer — Fri, 11 Jan 2019 06:18:30 GMT

What happens by the use of another browser like firefox or chrome? If it's worked it's an issue with the IE (settings) and if not it's a problem with the user/machine/network and it would be useful to check what happens on different ones (in both directions).

- Marcus

Re: Format Issues with INPUTFIELD

venkat_thota — Tue, 15 Jan 2019 15:49:59 GMT

No other browser installed in user machine. so I cannot test this scenario. I tested in my machine with Chrome and its working as expected. Taking decimals and converting them to %.

Re: Format Issues with INPUTFIELD

marcus_sommer — Tue, 15 Jan 2019 15:57:32 GMT

Why not installing a different browser maybe with the help of your IT (and deinstall it afterwards again or using the windows restore feature)? Did a user with this issue login on your machine and tried it there?

- Marcus

Re: Format Issues with INPUTFIELD

venkat_thota — Tue, 15 Jan 2019 16:07:32 GMT

I am on same page with you....I requested user to get the browser installed... I cannot push the business users to do it immediately.