Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
];