Filtered dimension selects another fields after selection

[ledi12]

Hi.

I have a filter pane where I do replace values dynamically based on variable (button qlik).

if(vPlanningLevel = 1, if([CNMT.METRIC_CODE] = 'PLAN VEHICLE ORDERS' or match(Tenant, '6') and match([business division code], 'CL', 'OR'), $1), $1)

It works however it also selects the fields used as filters in the above condition. I just want the one field to be selected.

for example $(calc_planning_level([Company])) should only select Company... Not metric_code, tenant etc.

How can I achieve it in qlik?

[SerhanKaraer]

Hello Ledi12,

You can try: aggr(if(vPlanningLevel = 1, if([CNMT.METRIC_CODE] = 'PLAN VEHICLE ORDERS' or match(Tenant, '6') and match([business division code], 'CL', 'OR'), $1), $1),$1)

[vinieme12]

this is how it works, since you are aggregating results based on other field values it is "A Combination of Filters"