topic Check if table exist through expressions in QlikView

Check if table exist through expressions

Sun, 15 Sep 2013 10:37:56 GMT

Hi all,

I would like to put a condition to display an object only if a certain table is created in my ERD.

what kind of expression should I use in the layout tab of the object properties?

thanks,

Boris

Re: Check if table exist through expressions

Sun, 15 Sep 2013 11:18:11 GMT

Hi Boris,

You can use the system field $Table to accomplish that, in the layout conditional field add the below to check if a table labeled Production exists or not:

SubStringCount(';' & Concat(DISTINCT $Table, ';') & ';', ';Production;')=1

Hope this helps.

Re: Check if table exist through expressions

Sun, 15 Sep 2013 13:03:48 GMT

I get an expression error under the $.

Re: Check if table exist through expressions

Sun, 15 Sep 2013 17:16:53 GMT

You can enclose the system field between brackets: [$Table].

But it will still work anyways

Re: Check if table exist through expressions

Fri, 20 Sep 2013 01:18:32 GMT

Boris,

Could you mark the answer as correct if it was the case.

This will also help others having same request.

Thanks.