Chart with a prefiltered filter

[Anonymous]

Hello qlikers 🙂 ,

I have a line chart. In this line chart I have two filters, plants and amount of employee. I want that in this line chart a certain filter ist prefiltered in plants and you shouldn't deselected the filter. I have a drilldown, if you select only 2 plants (prefiltered filter and another plant) the drilldown should be active and not more the prefiltered filter should be seen. 

How can I do that? Thank you in advance! 🙂

[JordyWegman]

Hi Steven,

I think you can work with a solution like this:

IF(GetSelectedCount([Plants] >2,
   Sum({$< Plants = {YourCondition}>}Employees),
   IF(GetSelectedCount([Plants] = 2,
       Sum(Employees),
       null()
   )
)

Jordy

Climber

[Anonymous]

Thank you. Where should I paste in this code? -

In my diagram in dimension there is my drilldown. Where should I poste your code in?