Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis - only one selection to affect results in table


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
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.