Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
cander19
Contributor II
Contributor II

Set Analysis within Organization Chart?

I have an organization chart and a filter for the 10 'functions' (Teams 1-10). By default, if no filter is selected, I only want to show 9 of the functions. But, if user selects a function from the filter pane, it displays accordingly. I tried using this expression on both dimensions but it did not work:

=if(GetSelectedCount([Function])=0,{<[Function]-={'Team10'}>}[Position Number],[Position Number])

=if(GetSelectedCount([Function])=0,{<[Function]-={'Team10'}>}[Reports to position],[Reports to position])

Is there a way to achieve this result?

Labels (3)
0 Replies