Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis - only one selection to affect results in table

Hello

I currently have a pivot table showing staff groups within the organisation this come from a staff list report ran every month, if people are still here they are duplicated as such i have created a field of date of report to remove duplIcates and allow for previous months reporting etc.

At moment i have "=count({$<MonthYear=>}Employee)" this gives me the figures but what i want is to have only the report effective date to change the table, all other selections the user makes should not affect the values. If i put a 1 in place of the dollar sign it ignores the user selections completely but then the figures are incorrect.

1 Reply
dirk_konings
Creator III
Creator III

maybe something like this :

=count({1 <MonthYear = P({$}MonthYearSelectionField)> Employee)

We count the employees for the MonthYear equal to all possible (or selected) values of MonthYearSelectionField.