topic Re: Expression Help...My Data should not change on some search criteria in QlikView

Expression Help...My Data should not change on some search criteria

Mon, 27 Jan 2014 14:41:52 GMT

Hi All,

My data should not change for a specific Search criteria.

My DATA should not change for r PROJECT_NAME,PROJECT_TYPE_LABEL,PROJECT_PHASE,WORKSPACE_TYPE_LABEL,BUSINESS_SPONSOR_NAME,BUSINESS_UNIT_LABEL

Here is my code :

if(wildmatch(only({1}CATEGORY_LABEL_SORT),20.5,24.5,21,0),'', Sum({$<PROJECT_NAME=,PROJECT_TYPE_LABEL=,PROJECT_PHASE=,WORKSPACE_TYPE_LABEL=,BUSINESS_SPONSOR_NAME=,BUSINESS_UNIT_LABEL=,CALENDAR_YEAR=,CALENDAR_PERIOD=,QuarterID ={"=$(=Max(QuarterID))"},FISCAL_YEAR = {"<=$(=Max(FISCAL_YEAR))"}>} DOLLAR_AMOUNT))

Re: Expression Help...My Data should not change on some search criteria

jerem1234 — Mon, 27 Jan 2014 14:46:30 GMT

Does your formula work but is changing on selecting those fields?

My guess is that in your set analysis, your max function needs those fields ignored as well.

like:

Max({<PROJECT_NAME=,PROJECT_TYPE_LABEL=,PROJECT_PHASE=,WORKSPACE_TYPE_LABEL=,BUSINESS_SPONSOR_NAME=,BUSINESS_UNIT_LABEL=,CALENDAR_YEAR=,CALENDAR_PERIOD=>}QuarterID)

Do the same for FISCAL_YEAR

Remove any fields you don't need or add any you need.

Hope this helps!