Issue using inputfields

Michael_Reese — Thu, 03 Nov 2011 19:01:40 GMT

I am trying to create a note field and add it to a table. I've tried this a number of different ways, but every time I try to add it to a table (which has not been created yet), it loses the input funcitonality.

I can create the input field in it's own table with a load * inline and it works fine if I leave it there, but that's not where I need it.

I have tried adding the field to the table I need it in using a left join, but the value turns to 0 (even though was created as 1), and the editing functionality is lost.

I've also tried creating the input field without using an intermediate table. Following the creation of the field, I create another table with a field matching the name of the input field. That doesn't work either.

Here are examples of what I tried that don't work:

Ex1.

inputfield TerritoryNote;

Territory:

Load TerritoryID,

1 as TerritoryNote

;

SQL Select TerritoryID from Territory;

inputfield TerritoryNote;

Territory:

Load * inline [

TerritoryNote

1];

Ex 2.

left join (Territory)

Load TerritoryID,

;

SQL Select TerritoryID from Territory;

Issue using inputfields

Michael_Reese — Thu, 03 Nov 2011 23:39:20 GMT

Table was not distinct.

topic Issue using inputfields in QlikView

Issue using inputfields

Issue using inputfields