topic Re: hide/show a text object based on a association in QlikView

hide/show a text object based on a association

Wed, 19 Nov 2014 21:16:50 GMT

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

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

kristoferahlin — Wed, 19 Nov 2014 22:11:39 GMT

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

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

danieloberbilli — Wed, 19 Nov 2014 22:39:17 GMT

Please find QVW attached

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

Wed, 19 Nov 2014 22:39:42 GMT

Thanks, but doesn't seem to work

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

Wed, 19 Nov 2014 22:50:08 GMT

Works like a charm...Thank you very much