Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
An issue has been identified on Qlik Cloud hub, please visit our Status Update Page for details: GET THE LATEST
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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

1 Reply
jerem1234
Specialist II
Specialist II

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!