topic Re: Accept User input value between 0 and 1 in QlikView

Accept User input value between 0 and 1

aj0031724 — Thu, 23 Feb 2017 11:59:40 GMT

Dear TEAM,

We need one input box to accept any number between 0 AND 1.IT could be any dev=cimenal values also between 0 AND 1.

For example ->0.0001 or 0.00000034 upto 9 decimal is allowed.

I created one VARIBLE with predefined values between 0 and 1 WITH STEP OF 0.000000001 .But it is not behabving correct.

Can you please guide and advise how to achive?

rahulpawarb — Thu, 23 Feb 2017 12:24:09 GMT

Hello Avinash,

You can apply the validation by setting background color of Input box if variable value is greater than 1 or less than 0.

Add below given expression as calculated background color for input box:

If($(vStep)>1 OR $(vStep) < 0, Red())

Regards!

Rahul

sasikanth — Thu, 23 Feb 2017 12:41:42 GMT

HI,

it might be because your step value is very low that we may get huge no. of values between 0 and 1.

is step value is mandatory (0.0000001)? any how input box allows to give user choice value

petter — Thu, 23 Feb 2017 13:15:13 GMT

Try instead to use "Input Constraints" / "Custom" and use this expression $>=0 AND $<=1