Qlik Community

Qlik Sense App Development

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

Announcements
Announcement: Certain actions are currently causing a Page Not Found error. This is a known issue and we are working with the platform vendor to investigate and resolve it.
Highlighted
geertdeman
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
Partner
Partner

Re: Filter list on field not displayed in list

Why not use set analysis something like
Filtercol-={'UNKNOWN'}
Partner
Partner

Re: Filter list on field not displayed in list

Try

only({<Filtercol-={'UNKNOWN'}>}showfield)
Please ekskuse my Norglish and Swenglish typos.