Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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! 🙂
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
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?