Set Analysis

[#1]

Hello i am a newbie to Qlikview and am trying to get my head around set analysis.

I have a pivot table which shows the count of employees per staff group. The staff report is ran every month as such many staff will be duplicates, the calculation should only be for one month (no duplicates) . I have a field called report efective date when this is selected, for example March then only employees within the report for March should show and the same if February was selected. However i only want this selection to change the figures in the pivot table no other selections should change the figures, for example training date. I hope this makes sense here is what i have so far, it allows me to make changes without changing the count but when i try to change the report effective date it does not change on that selection;

=count({1<[Report Effective Date]={}>}Employee)

[#2]

I've had to do something similar. I needed to disregard all selections, except for selections made in a single field.

Here is my solution:

//respecting only the selections that restrict user, and only for points that count towards the balance, sum all points.
sum({1<PRIMARYIDENTIFIER = P({PRIMARYIDENTIFIER}), COUNTS_TOWARD_BALANCE = {1} >} QUANTITY)

Let me break it down.

Sum quantity for:

{1 - disregard the selection criteria

<PRIMARYIDENTIFIER = P({PRIMARYIDENTIFIER}) for all curently possible primary identifiers

COUNTS_TOWARD_BALANCE = {1} >} Where this field is = 1.

The bit with the possible is the bit you need.

-Fry

[#3]

Cheer mate much appreciated managed it with your help