Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Qlikuser09
Creator II
Creator II

How to apply (1-$) to only one filter?

Count({1-$},[Name])) 

The above set analysis excludes the selected filter value and displays result. But i want this to be applied to only the Leader filter, i have few other filters like (Location , Department, Year,Owner etc), when i select the remaining filters the set analysis has to be filtered according to the value and exclude

 

Labels (5)
2 Replies
G3S
Creator III
Creator III

can try with getfieldselections  ?

Qlikuser09
Creator II
Creator II
Author

How to with getfieldselections in this case, 

Count({1-$(=GetFieldSelections([Name])},[ReportName])) is not working ( i wanted to exclude the selected values from the Name fieldfilter)