topic Re: System Fields in QlikView

System Fields

ryuma_nakano — Mon, 19 Sep 2016 23:07:01 GMT

Hi,

Is there a way to use system fields ($Table, $Field, $Fields ...) while script is still running???

Thanks for your help.

Re: System Fields

sunny_talwar — Tue, 20 Sep 2016 16:23:09 GMT

What do you want to use this for? There are Table functions ‒ QlikView such as

TableName()

NoOfTables()

NoOfFields()

FieldName()

Re: System Fields

ryuma_nakano — Tue, 20 Sep 2016 16:59:02 GMT

Hi Sunny,

I need to know the way to loop through a couple of tables while running the script and which name's may change during the process, so I wanted to see if there was a chance to get them dinamically.

I used a for loop that worked perfectly:

for i = 0 to NoOfTables() - 1

LET vTableName = TableName(i);

Re: System Fields

sunny_talwar — Tue, 20 Sep 2016 17:18:57 GMT

Awesome