Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

how to use inputfields

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.

noupdate.png

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

Thanks!

Tags (1)
1 Solution

Accepted Solutions

Re: how to use inputfields

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.


talk is cheap, supply exceeds demand
1 Reply

Re: how to use inputfields

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.


talk is cheap, supply exceeds demand
Community Browser