topic Re: Limitate values in inputfield? in QlikView

Limitate values in inputfield?

Fri, 26 Sep 2014 15:38:49 GMT

Hi guys!

One question, if i have this table for example

INPUTFIELD Telephone;

INPUTFIELD 'Postal Code';

LOAD * INLINE [

Country, Name, Telephone, Postal Code

Argentina, Carlos

Colombia, Sergio

China, Juana

Iran, Paula

];

And i want to limitate the kind of information that the user will input, for example in telephone i want only numbers and 8.

What i have to do?

Thank you all.

Re: Limitate values in inputfield?

fkeuroglian — Fri, 26 Sep 2014 15:42:31 GMT

Hi, try to use a slider object and create a variable that will be the value in this slider

the slider give you the possibility yo controle the value that will set the user

good luck

Fernando

Re: Limitate values in inputfield?

sathishkumar_go — Fri, 26 Sep 2014 15:47:33 GMT

No, input fields cannot be validated.

-Sathish

Re: Limitate values in inputfield?

Fri, 26 Sep 2014 15:51:04 GMT

Ok, but i need to create telephone numbers, i don't think that the slider object will be useful for me.

Thank you.

Re: Limitate values in inputfield?

Fri, 26 Sep 2014 15:52:15 GMT

Ok! Im very new in QV, and i don´t understaund a lot of thinks. What i have to do to make this thing works ? A variable? Im speaking about entrying telephone numbers in that object.

Thank you!

Re: Limitate values in inputfield?

fkeuroglian — Fri, 26 Sep 2014 15:59:28 GMT

You want to create telephone numbers and where do you want to store or save it?

in a bd? in a excel? or only show in the screen?

i think you want to add data to user for example, through qlikview is not the best way

Re: Limitate values in inputfield?

Fri, 26 Sep 2014 16:08:53 GMT

Mmm I dont know that answer haha, i know QV is not the best way to do this sort of things but i have to study this because in the company where i work there are a lot of clients that are wanting to interact with the QV adding numbers for example.

What is the difference in the code while storing in a BD, or EXCEL, or only showing in the screen?

And another question, what i have to do if i want to set a default value in one column for example in telephone i want to have the legend "Put telephone"

Thank you, and sory for my poor english.

Re: Limitate values in inputfield?

Fri, 26 Sep 2014 16:13:41 GMT

Are there more things to know about the INPUT FIELD? What are they common uses?