topic Set Analysis Issue in QlikView

Set Analysis Issue

Thu, 21 Jan 2010 03:03:05 GMT

Hello...I'm trying to use set analysis to display Prior Headcount in a headcount movement report:

Region

Prior Heacount Attrition Hires Net Other Total Delta Current Heacount

Business

Attrition, Hires, Net Other, Total Delta, and Current Heacount are all driven off the current month's data. For Prior Headcount, I'm using Set Analysis as follows:

Count({1<Month_Num={$(#=Month_Prev)},Description={'Constant','Hire','Other Adds','Transfer In'},[Employee_Non-Employee]={'Employee'}>}Current_Count)

The problem I'm having is if the user selects Business or Region to filter the report, all Businesses and/or Regions continue to display on the report. I believe this is happening because I'm doing the count on the entire data set. How can I get QV to respect the Business and Region selections even if I'm using 1 for the Set Identfier? Thanks.

Set Analysis Issue

Thu, 21 Jan 2010 03:48:18 GMT

What is the reason for using 1 in the set analysis. Not sure whether I am getting your data model. Can you post an example

Nmish

Set Analysis Issue

Thu, 21 Jan 2010 15:08:49 GMT

If we are looking at December movement, the Prior Headcount column is actually coming from November data. Since December is selected, I figured that in order to count November headcount, Set Identifier needs to be set to 1 so that the current selection is ignored.