Wierd Scenario in Selection search Criteria

[#1]

Hi All,

I have a requirement not to change the data based on selection search criteria except year and period.Basically if we select WorkSpacetype my QTD Should not be change.

But it is showing correctly except only for a particular selection search criteria.

In the attached file we have Work Space Type (Emergency Request ) my QTD is changing.

[Nicole-Smith]

Work Space Type (Emergency Request) doesn't have any 2014 data, so it isn't linked to the year 2014.  When you click on it, you're loosing your 2014 data.  If you want to fix this, you'll need to do something along these lines: http://community.qlik.com/blogs/qlikviewdesignblog/2013/02/05/populating-a-sparsely-populated-field

[Carlos_Reyes]

Nicole's suggestion is probably the best option to avoid creating complex set analysis formulas, however... if you want to continue with that kind of records you have to add the disregarding selections fields inside of the MAX PERIOD and MAX YEAR in order to avoid that these fields selections affect this value calulations. So... it would be something like the next:

Sum({$<PeriodID = {"<=$(=Max( {<,PROJECT_NAME=,PROJECT_TYPE_LABEL=,PROJECT_PHASE=,WORKSPACE_TYPE_LABEL=,BUSINESS_SPONSOR_NAME=,BUSINESS_UNIT_LABEL=,CALENDAR_QUARTER = ,CALENDAR_PERIOD = >} PeriodID))"},FISCAL_YEAR = {"<=$(=Max( {<,PROJECT_NAME=,PROJECT_TYPE_LABEL=,PROJECT_PHASE=,WORKSPACE_TYPE_LABEL=,BUSINESS_SPONSOR_NAME=,BUSINESS_UNIT_LABEL=,CALENDAR_QUARTER = ,CALENDAR_PERIOD =>} FISCAL_YEAR))"},PROJECT_NAME=,PROJECT_TYPE_LABEL=,PROJECT_PHASE=,WORKSPACE_TYPE_LABEL=,BUSINESS_SPONSOR_NAME=,BUSINESS_UNIT_LABEL=,CALENDAR_QUARTER = ,CALENDAR_PERIOD = >}DOLLAR_AMOUNT)