how to use inputfields

Fri, 16 Nov 2012 12:53:02 GMT

Hi everyone,

I want to learn how to use the input field.

I have a field called uretPlan which exists in 2 tables sonPlan and empOzet2(due to the join) and I would like to create a 3rd table where the field is an inputfield.

Is this possible or should the inputfield be unique to the table it resides in? The code below doesn't give an error but it doesn't turn the uretPlan field into an input field.

sonPlan:

LOAD planGrup, date(date#(empTerminTarih2)) as empTerminTarih2, empMinOncelik1, empMinSipNo,empDesen,empMa_kod, empVaryant,/* uretPlan*/, planHafta from $(myPath)$(vSonPlan).csv (txt, delimiter is ',');

Join(empOzet2) LOAD * Resident sonPlan;

INPUTFIELD uretPlan;

yeniPlan:

Load uretPlan, * Resident empOzet2;

I've also tried the following

INPUTFIELD uretPlan2;

yeniPlan:

Load 0 as uretPlan2, * Resident empOzet2;

This time I see uretPlan2 as an input field but when I try to change the value of the field the table doesn't reload it gets stuck.

Does anybody have an idea on how to fix this??

Thanks!

Re: how to use inputfields

Gysbert_Wassenaar — Sat, 17 Nov 2012 14:56:24 GMT

It seems you can't use input fields with a join or resident table. You'll have to save empOzet2 to a qvd first and then use that qvd with the inputfield load. See here and here for other discussions about this issue.

topic how to use inputfields in QlikView

how to use inputfields

Re: how to use inputfields