get the current Tablename

[entsh]

hello

I have two tables: table1 and table 2 

I want to define a variable that when I click on every field belong to table 1, when I call variable it returns  'table1'

or when I click on every field belong to table 2 t returns  'table2'

how can I do that?

thx

[Vegar · Accepted solution]

In QlikView you got this data available in you data model through the hidden system fields named $Table and $Field.

By using these you are able to filter between tables and fields in your data model.