Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
AWS Degraded - You may experience Community slowness, timeouts, or trouble accessing: LATEST HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
geertdeman
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)

 

Labels (2)
2 Replies
dplr-rn
Partner - Master III
Partner - Master III

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

Try

only({<Filtercol-={'UNKNOWN'}>}showfield)