topic inputfield in QlikView

inputfield

Wed, 16 Feb 2011 15:24:38 GMT

Hi,

I have created the inputfield and inicialized it with '0' values.

The problem is that every time I close the model and I turn to open it the field has new values that I never introduced and I have to reload to solve that,

any idea?

Thanks

inputfield

vgutkovsky — Thu, 17 Feb 2011 01:44:12 GMT

Yep, I've seen that one before. Make sure that your declaration of inputfields is the very last thing you do in your script. If you have that field before, then prior to declaring it an inputfield call it a different name. Then alias it at the end. For example, if your field is myfield, then your script can look as follows:

mytable:
LOAD
myfield as myfieldtemp
FROM datasource.qvd (qvd);

Then at the end you can change it to an inputfield:

INPUTFIELD myfield;

myfinaltable:
LOAD
myfieldtemp as myfield
RESIDENT mytable;

Regards,

inputfield

Thu, 17 Feb 2011 13:34:11 GMT

Hi Vlad,

I have tried it but it doesn't work propperly, the inputfield turns to 0 but It doesn't allow me to change its values (it becomes a normal field)

Here is the code I have used after your advice I don't know what I'm doing wrong:

left join (TABLE1)load RULE_ID,

0 AS ATEMP

RESIDENT TABLE1;

left join (TABLE1) load RULE_ID,

A AS ATEMP

RESIDENT TABLE1;

inputfield A;

left join (TABLE1)load RULE_ID,

ATEMP AS A

RESIDENT TABLE1;

inputfield

Thu, 17 Feb 2011 17:08:23 GMT

It works,

I thought I could do it with joins but I was wrong

Thank you Vlad!