topic Re: Predefined values in an inputfield in QlikView

Predefined values in an inputfield

Fri, 25 Apr 2014 21:03:13 GMT

Hi,

Just a short question.

Is it possible to predefine values for an Inputfield?

Brg

//K

Re: Predefined values in an inputfield

rwunderlich — Fri, 25 Apr 2014 21:33:43 GMT

Yes. Load the field with a predefined value in the script. This is usually done by copying an existing value. For example:

INPUTFIELD BudgetForecast;

LOAD

BudgetAmount,

BudgetAmount as BudgetForecast

FROM ...

-Rob

Re: Predefined values in an inputfield

Fri, 25 Apr 2014 21:44:32 GMT

Hi Rob

Thanks for your answer.

What I want to do is limit the text values the user can write/chose from.

In this case the user should valuate why a shipment was late.

Like:

Late truck

Wrong material

etc

Brg//K

Re: Predefined values in an inputfield

Anonymous — Tue, 20 May 2014 09:36:09 GMT

Hi Klas,

I am faced with a similar request.

Did you manage to solve it?

Thanks,

Antoine

Re: Predefined values in an inputfield

Tue, 20 May 2014 09:38:26 GMT

The only way to truely limit w text string is to define what a user can input i.e. a defined list such as in Robs example

Re: Predefined values in an inputfield

Tue, 20 May 2014 09:43:54 GMT

Hi,

No, if it was numbers I wanted to enter I could use InputSum or InputAvg but in my case I want to write text as an explanation to why something went wrong.

My solution was to make an Inline list of pre-defined textstrings to be used and show them in a listbox. and then a tablebox where the user can copy the pre-defined vaues into.

brg

//Klas