Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
New Contributor

Filter list on field not displayed in list

In qlik sense I want to filter a list in a report based on a column (Filtercol) that is not in the list (or should not be visible in the list).  I used another column (showfield) to display the vaule of showfield column  if the condition is not true, otherwise Null value will be returned.  In the list I exclude the null values for this column

The following condition is working but is very slow:  if(Filtercol='UNKNOWN',null(),showfield)


2 Replies
Valued Contributor III

Re: Filter list on field not displayed in list

Why not use set analysis something like
Valued Contributor II

Re: Filter list on field not displayed in list


Please ekskuse my Norglish and Swenglish typos.
Community Browser