topic Table Box with filtered field values in QlikView

Table Box with filtered field values

Thu, 02 Jan 2014 16:03:57 GMT

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.

Re: Table Box with filtered field values

Anonymous — Thu, 02 Jan 2014 16:06:44 GMT

Steve

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

Best Regards, Bill

Re: Table Box with filtered field values

Anonymous — Thu, 02 Jan 2014 16:11:45 GMT

Or create an additional field in the script:

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

Regards,

Michael

Re: Table Box with filtered field values

Thu, 02 Jan 2014 16:18:15 GMT

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()

Re: Table Box with filtered field values

Nicole-Smith — Thu, 02 Jan 2014 16:30:11 GMT

For a dimension:

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

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.