Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
priyanka08
Contributor III
Contributor III

NTName at Qlikview Access by default set to Qlikview instead of os User name

I have implemented the section access like  if login  it should display certain tab only and hide others which is working fine on local desktop system.

but once I checked the same on access point it take  NTNAME as reg1\qlikview instead of reg1\priya

thats why section access not able to hide tab . 

Is there is any such settings in Qlikview access point

 

Labels (1)
1 Reply
priyanka08
Contributor III
Contributor III
Author

Section Access;
Userslist:
LOAD UPPER(TRIM(userid)) AS NTNAME, // USERID,//
Upper(trim(access)) AS ACCESS,
UPPER(IF(UPPER(access)<>'ADMIN' and country_access='*','COUNTRY_GROUP_ALL',country_access) ) AS Group_Country_Access,
UPPER(debtor_wmnc_rm_country) AS Group_Debtor_Country_Access,
UPPER(wmnc_access) AS WMNC_Access,
UPPER(lps_access) AS LPS_Access
Resident TempSectionAccess order by access desc;

Section Application;

Tab_Access:
LOAD UPPER(TRIM(userid)) AS NTNAME, //USERID,//
main as Main,
summary as Summary,
seller as Seller,
debtor as Debtor,
details as Details,
[debtor_bm] as [Debtor_BM],
[debtor_rm] as [Debtor_RM],
margin as Margin,
pipeline as Pipeline

FROM
$(vStage0_QvdPath)Manual\SectionAccess.qvd(qvd) Where arp_ct_dashboard=1 ;

 

 

this is coming in osUser

priyanka08_0-1667033132401.png

NTNAMe

priyanka08_1-1667033153797.png