QlikView App Dev

[samuel_brierley]

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;

[#2]

how to use inputfield

[samuel_brierley]

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

[albi_prakash]

Hi Samuel,

  Is that possible to share your App

-Jai

[dsharmaqv]

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;