On Field selection filter should apply.

[MuraliPrasath]

Hi Qlik,

I have a table chart when someone selects any Date filter, then my "Project Status" field should show only the Completed value only. else all the Project Status (Completed, In-progress, Not Started) should be displayed.

I tried below but no luck.

=if(GetFieldSelections([Date])>1,[Project Status]='Completed',[Project Status])

[AronC · Accepted solution]

=if(GetFieldSelections([Date])>1, aggr(only({<[Project Status]='Completed'>}[Project Status],[Project Status]),[Project Status])

[MuraliPrasath]

Thanks AronC 🙂

[AronC]

@MuraliPrasath You might need to add nodistinct to make it work. 

=if(GetFieldSelections([Date])>1, aggr(nodistinct only({<[Project Status]='Completed'>}[Project Status],[Project Status]),[Project Status])