Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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)
this is how it works, since you are aggregating results based on other field values it is "A Combination of Filters"