Hide tables

[Anonymous]

I have following table in script

Table1:

LOAD * INLINE [

Key,A

1,A1

2,A2

3,A3

];

NoConcatenate

Table2:

LOAD * INLINE [

Key,C

1,C1

2,C2

4,C4

];

Table3:

LEFT JOIN (Table1)

load * resident Table2;

Is there any way that only Table3 should be available for user (means Table1 and Table2 should be hidden) for various action like creation of chart etc. I cannot drop the Table1 and Table2

[Oleg_Troyansky]

Hi Amar,

Because of the JOIN, the label Table3 is being ignored by the script. The data from Table2 is being joined into Table1.

After that, you MUST drop Table1, or else the common fields between Table1 and Table2 will form a Synthetic key and an undesired link.

To answer your general question - data tables that are not dropped, cannot be fully disabled ("hidden") from the users.

The best you can do is to hide fields using HidePrefix and HideSuffix, but even then the fields will not be easily visible, but they are still available for charts and sheet objects.

Cheers,

Oleg Troyansky

Master your Qlik skills with my book QlikView Your Business: An Expert Guide to Business Discovery with QlikView and Qlik Sense

[florentina_doga]

use this

Table3:

LOAD * INLINE [Key,A

1,A1

2,A2

3,A3

];

Outer join(Table3)

LOAD * INLINE [Key,C

1,C1

2,C2

4,C4

];