topic Re: Filter list on field not displayed in list in App Development

Filter list on field not displayed in list

geertdeman — Sat, 16 Nov 2024 06:52:27 GMT

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)

Re: Filter list on field not displayed in list

dplr-rn — Fri, 11 Jan 2019 14:55:20 GMT

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

Re: Filter list on field not displayed in list

Vegar — Fri, 11 Jan 2019 22:32:08 GMT

Try

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