Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Employee
Employee

Issue using inputfields

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;

1 Solution

Accepted Solutions
Employee
Employee

Issue using inputfields

Table was not distinct.

1 Reply
Employee
Employee

Issue using inputfields

Table was not distinct.

Community Browser