topic Filter a table in App Development

Filter a table

Wed, 18 Oct 2017 14:52:27 GMT

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

Re: Filter a table

felipedl — Wed, 18 Oct 2017 16:08:40 GMT

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.

Re: Filter a table

Thu, 19 Oct 2017 06:56:37 GMT

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