Qlik Community

Qlik Sense App Development

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

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

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
Highlighted
Partner
Partner

Re: Filter list on field not displayed in list

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

Re: Filter list on field not displayed in list

Try

only({<Filtercol-={'UNKNOWN'}>}showfield)
Plees ekskuse my Swenglish and or Norweglish spelling misstakes