I am trying to run a simple application using NTName to show or hide tabs based on the user who has logged in. Please find below the code that I used. The sample code doesn't work either in the dektop version or the qlikview server.
In the given example Sheet1 and Sheet2 refers to two tabs in my qlikview document.
Sheet1: -> Properties-> Show conditional: =Only(Sheet1)='X' is the expression that I have given. From the below example Sheet1='X' only for user JOHN.
SECTION ACCESS;
LOAD * INLINE
[ACCESS,NTNAME,ACCESSID
ADMIN,NA\JOHN,1
USER,NA\DOE,2
];
SECTION APPLICATION;
LOAD * INLINE
[ACCESSID,Sheet1,Sheet2
1,X,
2,N,X
];
The initiate Data Reduction based on Section Access, Strict Exclusion and Prohibit binary load are checked in the document properties->Openeing tab. Under the Document Properties -> Security tab -> Reduce data is also checked.
