topic Re: set limit to input field in QlikView

set limit to input field

devarasu07 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Please refer to the attachment, Is there any way to set limit to input field column ?

below screen shot, refer the highlighted "Adjustment Sales" <100% (it should not allow user to enter more than 100%). do you have any suggestion on this? thanks in advance

Re: set limit to input field

sunny_talwar — Tue, 27 Dec 2016 23:35:38 GMT

AFAIK this isn't possible, but I would be curious to see if I can be proven wrong

Re: set limit to input field

tamilarasu — Wed, 28 Dec 2016 03:10:53 GMT

Hi Devarasu,

You can simply show some warning message like attached screenshot. The textbox popup will appear and alert the user only when they enter Adjustment Sales more than 100%.

You can also use macro (triggered automatcially when the user enter more than 100%) and change the column value to "Exceeded" or even filter the lines automatically. But it is hard to maintain and slow when you have larger data. So I would suggest you to use textbox popup method since it is simple and easy to understand. See attached file for better understanding.

Re: set limit to input field

jayanttibhe — Wed, 28 Dec 2016 04:01:43 GMT

On top of it - can also change the text color to white if user value more than your specified number.

Like :=if(InputSum([Contribution%])>1,White())

Thanks

Jayant

Re: set limit to input field

tresB — Wed, 28 Dec 2016 04:58:45 GMT

I am not sure if I understood right. May be you can play around with Constraints of the input box (properties) like in attached.

Re: set limit to input field

praveen_prithiviraj — Wed, 28 Dec 2016 08:47:59 GMT

Try this

if(InputSum([Contribution%])<100%,[Contribution%])