topic Re: How to hide many small table in view data model ? in QlikView

How to hide many small table in view data model ?

paulyeo11 — Fri, 04 Sep 2015 05:40:40 GMT

Hi All

My data model alway very confuse , and i like to know it there a way to hide these small table ?

Re: How to hide many small table in view data model ?

Fri, 04 Sep 2015 05:42:33 GMT

Hi,

Better use a link table.

Re: How to hide many small table in view data model ?

sunny_talwar — Fri, 04 Sep 2015 05:42:47 GMT

I doubt that it is possible.

Re: How to hide many small table in view data model ?

tresB — Fri, 04 Sep 2015 05:43:32 GMT

AFAIK, not possible.

Re: How to hide many small table in view data model ?

Digvijay_Singh — Fri, 04 Sep 2015 05:46:13 GMT

I don't think it is possible, even you arrange them one above other and minimize as much as possible, they may appear differently when we make any further changes in data model?

Re: How to hide many small table in view data model ?

krishna20 — Fri, 04 Sep 2015 05:59:59 GMT

tresesco

and

sunindia

what happens if we drop that ISLAND tables? whether we can use that fields in the expressions or not??

If we can use those fields in the expressions. We can drop that tables to minimize the datamodel structure right??

Please clarify this doubt.

Re: How to hide many small table in view data model ?

sunny_talwar — Fri, 04 Sep 2015 06:01:43 GMT

Once dropped from the script, the fields in the ISLAND tables cannot be used anymore cause they are not available in data model anymore.

Re: How to hide many small table in view data model ?

krishna20 — Fri, 04 Sep 2015 06:04:40 GMT

Thank you sunny...

Re: How to hide many small table in view data model ?

sunny_talwar — Fri, 04 Sep 2015 06:06:58 GMT

No problem friend

Re: How to hide many small table in view data model ?

petter — Fri, 04 Sep 2015 06:28:45 GMT

You can achieve to "hide" tables in the Table Viewer by making each window as small as possible and then stack them on top of each other. Finally you make a dummy table in the end of your load script which you give a name like "DATA MODEL FOR APPLICATION XYZ". This one you make only as tall as the title line and as wide as you need to show the table name. And then you place this on top of the others. Have a look at my image where it has 5 hidden (behind) tables and one dummy table on top to cover them all that pose as a title for the entire data model.

This next screenshot shows the 5 hidden tables stacked on top of each other but with the "title" table moved up so it doesnt cover them anymore...

This layout manipulation will stay in effect through saves and reloads. But if you press Auto-Layout in the Table Viewer you will have to manually resize, move and restack the things you want to "clean" up visually...