Dynamic Tablebox based on Listbox selections

haymarketpaul — Thu, 09 Feb 2012 12:28:57 GMT

Hi All

Using QV11.

I have a listbox with a list of say 5 fields in it.

If the user selects say 3 of these i would like to display/populate a tablebox with only the fields the user has selected from the listbox and thie rassociated data.

For example:

I have a listbox: FIELDS

with...

Field1

Field2

...

Field5

The user selects Field1, Field2 & Field3

I have tablebox or straight table chart that then has these 3 selected fields in it as the column headers and all the associated data underneath each column.

I am thinking some sort of macro to create and populate the tablebox on the fly.

Any ideas?

Dynamic Tablebox based on Listbox selections

Thu, 09 Feb 2012 12:45:17 GMT

If you use a straight table you can hide/show an expression.

For instance you could use if(GetFieldSelections(specific_field)<>null())

topic Dynamic Tablebox based on Listbox selections in QlikView

Dynamic Tablebox based on Listbox selections

Dynamic Tablebox based on Listbox selections