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

Announcements
AWS Degraded - You may experience Community slowness, timeouts, or trouble accessing: LATEST 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.

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.