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

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
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