Ignoring filter for a line graph?

[user467341]

Hi,

I have a line graph using a calculated measures:

(Sum(A) - Sum({$<B= {'Car', 'Van'}>} A) - Sum({$<C= {"26"}>} A)) / Sum(A)

with dimension Month and Department.

Whenever I do some filtering, this line graph will also react to it. I want the line graph to react only to Department dimension, that is if someone select a department, it will filter to that department. Due to data modeling, if someone select a dimension called employee, it will affect this line graph! I want to avoid all other filter selection except department.

How can I achieve this?

Thanks

[Oleg_Troyansky · Accepted solution]

Hi there,

So, to disregard all user selections, you can use the Set Analysis Identifier {1} (instead of the $), and to leep the selection of Department, you can bring it back with the function P, like this:

Department = P({$})

So, your overall formula should look like this:

{1<Department = P({$})>}    (Sum(A) - Sum({<B= {'Car', 'Van'}>} A) - Sum({<C= {"26"}>} A)) / Sum(A)

If this doesn't work, or if you are using an older version of Qlik Sense, then you should populate the same Set Analysis in each one of the aggregation functions.

To learn more advanced development techniques, check out the agenda of the Masters Summit for Qlik - coming soon to Orlando and to Dublin!