Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

hide/show a text object based on a association

Hi All,

How can I hide/show a text object based on a association?

For eg: I click on a list box called Manager Name, Bob....by qlikview's associative nature all the employees ( another list box) get auto linked in white. Out of the list of these associated employees if one of them is called " UNASSIGNED", I will hide a text box, else show it. How can I do it?

Regards,

Tutan

1 Solution

Accepted Solutions
danieloberbilli
Specialist II
Specialist II

Please find QVW attached

View solution in original post

4 Replies
kristoferahlin
Partner - Contributor III
Partner - Contributor III

In the Layout tab of the text box properties, use this as condition for showing/displaying the box:

=SubStringCount(Concat(Employee), 'UNASSIGNED') > 0

Regards,

Kristofer

danieloberbilli
Specialist II
Specialist II

Please find QVW attached

Not applicable
Author

Thanks, but doesn't seem to work

Not applicable
Author

Works like a charm...Thank you very much