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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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.

Labels (1)
1 Solution

Accepted Solutions
swuehl
Champion III
Champion III

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
Champion III
Champion III

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.