topic Programatically Adding a Column to a ChartBox in QlikView https://community.qlik.com/t5/QlikView/Programatically-Adding-a-Column-to-a-ChartBox/m-p/239962#M90519 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have a number of Tables, let call them:</P><UL><LI>Table1</LI><LI>Table2</LI><LI>etc.</LI></UL><P>Each of these tables has different columns but they do all share a common key called pkey(inventive I know).</P><P>So I want to populate the columns in a TableBox depending on which TableName I've selected from a list.</P><P>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.</P><P>My problems are(one of my many):</P><UL><LI>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?</LI><LI>Is a table in qlik an object type in the model? If so can I load it using a variable name</LI></UL><P>Cheers</P><P>Jamie</P><P></P><P></P><P></P></BODY></HTML> Thu, 13 May 2010 17:17:37 GMT 2010-05-13T17:17:37Z Programatically Adding a Column to a ChartBox https://community.qlik.com/t5/QlikView/Programatically-Adding-a-Column-to-a-ChartBox/m-p/239962#M90519 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have a number of Tables, let call them:</P><UL><LI>Table1</LI><LI>Table2</LI><LI>etc.</LI></UL><P>Each of these tables has different columns but they do all share a common key called pkey(inventive I know).</P><P>So I want to populate the columns in a TableBox depending on which TableName I've selected from a list.</P><P>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.</P><P>My problems are(one of my many):</P><UL><LI>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?</LI><LI>Is a table in qlik an object type in the model? If so can I load it using a variable name</LI></UL><P>Cheers</P><P>Jamie</P><P></P><P></P><P></P></BODY></HTML> Thu, 13 May 2010 17:17:37 GMT https://community.qlik.com/t5/QlikView/Programatically-Adding-a-Column-to-a-ChartBox/m-p/239962#M90519 2010-05-13T17:17:37Z