Incorrect NTNAMES fetched when distributed via QMC

[amar_never_dies]

Hi All,

I am implementing show/hide of tabs based on NTNAMES or ROLES defined thorugh an input Excel file. The code works fine on local desktop and on server when opened in Qlikview APP. It works fine even we reload it via QMC but once after the APP is distributed through a distribution job , it assigns the QV_ADMIN NTNAME to each user on server/access point when they open the APP in browser (IE Plug-IN). We are using Qlikview 11.20 SR12 version.

Can anyone helps me to find out the root cause of it or any alternative solution on how i can make it work on Acces point.

This is the sample code i am using for NTNAME

Temp_AccessTable:
LOAD Trim(Upper(ACCESS)) as ACCESS,
Trim(Upper(NTNAME)) as NTNAME
FROM
Excel_File.xlsx
(ooxml, embedded labels, table is Finance);
/****************************************************************/

AccessTable:
NoConcatenate LOAD *
Resident Temp_AccessTable;

DROP Table Temp_AccessTable;

/****************************************************************/

SECTION Access;
NoConcatenate
LOAD //ACCESS,
  NTNAME 
Resident AccessTable;

/****************************************************************/

SECTION Application;

==============================================================