Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

RutiTRubin
Contributor

Filter in table - Qlik Sense

Hi,

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?

Thank's!!

1 Reply
OmarBenSalem
Esteemed Contributor

Re: Filter in table - Qlik Sense

u'll have to change the measure of ur table;

if(getselectedcount([Snapshot Date])=0,

sum({<[Snapshot Date]={"$(=max([Snapshot Date]))"}>}YourMeasure),

sum(YourMeasure)

)

Community Browser