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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Table Box with filtered field values

I am trying to create a table box chart and for one of the available fields "SI Programs" I only want to display 2 specific values (Growth and TBA).  The field currently has 8 values but the others are irrevalent to what I am trying to display.

Is there a way to add a fitler like if(SI Programs = 'Growth' or 'TBA', SI Programs)?  I cant see how to add an expression as a field in the table box.

4 Replies
Anonymous
Not applicable
Author

Steve

You will need to use a Chart of type Straight Table, and then quite likely Set Analysis in your expression.

Best Regards,     Bill

Anonymous
Not applicable
Author

Or create an additional field in the script:

if(match("SI Programs", 'Growth', 'TBA'), SI Programs, null()) as "SI Programs Restricted"

Regards,

Michael


Not applicable
Author

how would I use set analysis for the expression.  Not sure what function i would use against the "SI Programs" field since I am just trying to return text values.

maybe max()

Nicole-Smith

For a dimension:

=aggr(only({<[SI Programs]={'Growth', 'TBA'}>}[SI Programs]), [SI Programs])

or

For an expression:

only({<[SI Programs]={'Growth', 'TBA'}>}[SI Programs])

It all depends on how you're setting your table up if you need the dimension or expression.