Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Programatically Adding a Column to a ChartBox

Hi,

I have a number of Tables, let call them:

  • Table1
  • Table2
  • etc.

Each of these tables has different columns but they do all share a common key called pkey(inventive I know).

So I want to populate the columns in a TableBox depending on which TableName I've selected from a list.

Obviously i'm using vbscript to try and do this, I've seen a number of example with dynamic expressions and dimensions but nothing with dynamic tables and columns.

My problems are(one of my many):

  • If I have the Table name in a var can I extract a list of it's columns. So Table1.A, Table1.B, Table1.pkey?
  • Is a table in qlik an object type in the model? If so can I load it using a variable name

Cheers

Jamie

0 Replies