topic Input field not working in QlikView

Input field not working

samuel_brierley — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

for some reason my input field isnt allowing me to enter anything and i cant work out why.

firstly I create the input field (Congestion_Threshold). i then reload that table providing the field with the input field property. later on i drop the field from table 1 to avoid sync tables.

can anyone see where i've gone wrong?

Table1:

LOAD

northing,

easting,

northingend,

eastingend,

Time,

Date,

congestionpercent,

currentflow,

averagespeed,

linkstatus_typeid,

linktraveltime,

systemcodenumber,

60 as Congestion_Threshold,

//autonumber(systemcodenumber & lastupdated) as %Scoot_id, //use this one when live

autonumber(systemcodenumber & Date & Time) as %Scoot_id

//autonumber(systemcodenumber) as %scn

FROM

[XX]

(qvd);

INPUTFIELD Congestion_Threshold;

table2:

LOAD

systemcodenumber,

northing,

easting,

northingend,

eastingend,

Congestion_Threshold,

min(linktraveltime) as Min_TravelTime

Resident Table1

group by

systemcodenumber,

northing,

easting,

northingend,

eastingend,

Congestion_Threshold;

Re: Input field not working

Wed, 11 Jan 2017 11:41:30 GMT

how to use inputfield

Re: Input field not working

samuel_brierley — Wed, 11 Jan 2017 11:43:21 GMT

I've read that and I believe my script is compliant with what is said.

Re: Input field not working

Anonymous — Wed, 11 Jan 2017 11:48:32 GMT

Hi Samuel,

Is that possible to share your App

-Jai

Re: Input field not working

dsharmaqv — Wed, 11 Jan 2017 12:29:39 GMT

INPUTFIELD works only for table box object not for others

Also add RowNo() or any unique identifier for better results

INPUTFIELD Congestion_Threshold;

table2:

NoConcatenate LOAD

RowNo() As ID,

systemcodenumber,

northing,

easting,

northingend,

eastingend,

Congestion_Threshold,

min(linktraveltime) as Min_TravelTime

Resident Table1

group by

systemcodenumber,

northing,

easting,

northingend,

eastingend,

Congestion_Threshold

Resident Table1;