Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Filter a table

Hi

Qlik noob - tried searching but perhaps not aware of what lingo to use just yet.

I have a table and I would like to filter it according to 1 specific field, without using Selections / Filter Pane (i.e. a constant parameter).  I also don't want to add the parameter field to the table.

So say I have dozens of fields.  I have a field called [QRT] but I do not add this to the table.  I would like the table to only display records where [QRT] = 'S0602'.

Can someone offer me a steer please?

Thanks

Jon

2 Replies
felipedl
Partner - Specialist III
Partner - Specialist III

Hi Jon,

You'd have to use set analysis for that.

As an example, say you want the sum of sales for the QRT field equal to S0602, you would need to do the following:

sum({<QRT={'S0602'}>}Sales)

The bolded part {<QRT={'S0602'}>} would be the "filter" based on some criteria you want, even though you didn't select anything and the field is not on your table.

Felipe.

Not applicable
Author

Hi Felipe

Thank you for your suggestion.  However in this case I do not want to aggregate any numeric results.  Mine is a table of text values and I want to limit records according to a criterion.  QRT is a field (not in table) and I want to only show records that are associated where [QRT] = 'S0602'.

Thanks

Jon