Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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
Valued Contributor II

Re: hide/show a text object based on a association

Please find QVW attached

4 Replies
kristoferahlin
New Contributor III

Re: hide/show a text object based on a association

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
Valued Contributor II

Re: hide/show a text object based on a association

Please find QVW attached

Not applicable

Re: hide/show a text object based on a association

Thanks, but doesn't seem to work

Not applicable

Re: hide/show a text object based on a association

Works like a charm...Thank you very much

Community Browser