hide/show a text object based on a association

[#1]

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

[kristoferahlin]

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 · Accepted solution]

Please find QVW attached

[#4]

Thanks, but doesn't seem to work

[#5]

Works like a charm...Thank you very much