topic Re: list inline load field in a text box in QlikView

list inline load field in a text box

Anonymous — Wed, 10 Sep 2014 13:36:14 GMT

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

Re: list inline load field in a text box

cheburashka — Wed, 10 Sep 2014 13:43:08 GMT

Hi Farai,

Can you define your problem a bit better?

What exactly isn't working?

,KR Koen

Re: list inline load field in a text box

Anonymous — Wed, 10 Sep 2014 13:47:07 GMT

Hi Keon,

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

Re: list inline load field in a text box

Anonymous — Wed, 10 Sep 2014 13:58:10 GMT

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

thanx

Re: list inline load field in a text box

cheburashka — Wed, 10 Sep 2014 14:36:02 GMT

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

Re: list inline load field in a text box

Anonymous — Wed, 10 Sep 2014 14:40:04 GMT

Yes because i am manually listing the variables

Re: list inline load field in a text box

Wed, 10 Sep 2014 14:41:39 GMT

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.

Re: list inline load field in a text box

Anonymous — Wed, 10 Sep 2014 14:48:59 GMT

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

Re: list inline load field in a text box

cheburashka — Wed, 10 Sep 2014 14:56:18 GMT

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?

Re: list inline load field in a text box

Wed, 10 Sep 2014 14:57:58 GMT

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?

Re: list inline load field in a text box

Anonymous — Wed, 10 Sep 2014 15:00:54 GMT

yes thats right

Re: list inline load field in a text box

Wed, 10 Sep 2014 15:03:45 GMT

In that case the solution I have provided should work.

Re: Re: list inline load field in a text box

Anonymous — Wed, 10 Sep 2014 15:03:58 GMT

i want to show the tables in a text box

Re: Re: Re: list inline load field in a text box

Wed, 10 Sep 2014 15:07:35 GMT

You can have a look at the attached example.

Re: list inline load field in a text box

cheburashka — Wed, 10 Sep 2014 16:16:47 GMT

farai huruba

Don't forget to mark the discussion as answered.

,Koen