list inline load field in a text box

[Anonymous]

hi All, i am trying to get all variables (names) i have used in the load script and load them as an inline table and list them in a text box

all the variable are defined on a separate text file

[cheburashka]

Hi Farai,

Can you define your problem a bit better?

What exactly isn't working?

,KR Koen

[Anonymous]

Hi Keon,

i let me upload a sample of what i am trying to do

[Anonymous]

i have attached the same the desired result is text box in red but showing the 'DatabaseTables' field

thanx

[cheburashka]

Hello Farai,

Does the inline table "DatabaseTables" that you create contain the values that you want?

If Im correct you just want to show all the values of a field "DatabaseTables" in a text box instead of a tablebox?

,Koen

[Anonymous]

Yes because i am manually listing the variables

[#7]

If I have understood your requirement correctly, you can do something like this

Let vTableName='';

Let vCount=0;

FOR i = 0 to NoOfTables()

// TableList:

// LOAD TableName($(i)) as Tablename AUTOGENERATE 1;

  Let vTableName='$(vTableName)' & Chr(13) & TableName($(i));

  Let vCount=$(vCount)+1;

Next;

Then in your text object use =vTableName as Text and  ='No of Tables: ' & vCount as caption.

[Anonymous]

Hi thanx for the reply but the thing is the table names are different and are defined as per the Database table name being queried

not sure if u get me right there

[cheburashka]

Can you confirm on this question:

If Im correct you just want to show all the values of a field "DatabaseTables" in a text box instead of a tablebox?

[#10]

Hi Farai,

NoOfTables() and TableName() are in built qlikview functions so it does not matter which table names you have. It should fetch the table names already loaded in the script.

Can you confirm what do you want to show? Do you want to show the table names or the variables to which tables are assigned?