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

Announcements
Only at Qlik Connect! Guest keynote Jesse Cole shares his secrets for daring to be different. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to Create TableBox with Selectable Columns

How can I make a TableBox (or something equivalent) that allows me to populate said object with whatever fields I select from a listbox? The reason I would like to be able to make this is because I don't want to have to reference Excel for questions about my data. Instead, I want to basically have that Excel sheet on Qlikview, but be able to pick which columns I'm looking at.

1 Solution

Accepted Solutions
swuehl
MVP
MVP

You can use a straight table object with conditional dimensions (you don't need expressions, just disable 'suppress zero values' on presentation tab), like described here:

Customizable Straight Table

Remember to select a primary key of your excel table, so you will see all rows of your Excel table, not just distinct combinations of dimensional values.

View solution in original post

1 Reply
swuehl
MVP
MVP

You can use a straight table object with conditional dimensions (you don't need expressions, just disable 'suppress zero values' on presentation tab), like described here:

Customizable Straight Table

Remember to select a primary key of your excel table, so you will see all rows of your Excel table, not just distinct combinations of dimensional values.