Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
paulyeo11
Valued Contributor II

How to hide many small table in view data model ?

Hi All

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

small table.png

9 Replies
Not applicable

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

Hi,

Better use a link table.

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

I doubt that it is possible.

MVP
MVP

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

AFAIK, not possible.

Digvijay_Singh
Honored Contributor III

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

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?

krishna20
Valued Contributor

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

Hi

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 ?

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

krishna20
Valued Contributor

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

Thank you sunny...

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

No problem friend

MVP
MVP

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

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.

2015-09-04 #3.png

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...

2015-09-04 #4.png

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...

Community Browser