Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.


Filter in table - Qlik Sense


I create table with dim field named "Snapshot Date" -

I also have filter pane named  "Snapshot Date"  that connected to the field in the table.

I want that In case the user will select a value in filter "Snapshot Date" the table will display only the selection date else will display the max value date in field "Snapshot Date".

I try the following expression - but it doesn't work:

if(GetFieldSelections([Snapshot Date])=0,MaxString(Text([Snapshot Date])),'')

Any Idea?


1 Reply
Honored Contributor

Re: Filter in table - Qlik Sense

I think that instead of the empty quotes at the end you need to insert the value that they selected in the filter.

So you need to use GetFieldSelections({Snapshot Date]) at the end and change the first one to GetSelectedCount = 0

Community Browser