Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
michaelneck
Contributor III
Contributor III

Qlik Server User Group ID Number & Section Access ID Number Mismatch

Hi All,

I am having an issue which I think is down to a mismatch in the number formats between the Qlik Server User Group and my excel based Section Access File.

On the server the id number has a leading 0 for example: 01234

In the excel the id number obviously has no leading 0 just 1234

This seems to be causing an issue when using the numbers to create section access as the user cannot access the application through the access portal.

I have tried to solve this using the below in my section access script in my app when loading in the field from the external section access excel sheet but this does not seem to work.

NUM(ID_Number),00000)

if(len(ID_Number)<5, '0' & ID_Number, ID_Number)

Does anyone have any idea how I could solve this issue?

Thanks and any help would be greatly appreciated.

 

 

3 Replies
marcus_sommer

Do you mean with User Group an active directory group which is used in NTNAME or is it a field for a data-reduction?

- Marcus

michaelneck
Contributor III
Contributor III
Author

Hi Marcus,

Please see below.

USERGROUPS_MAP:
MAPPING LOAD
'AD\'& if(len([ID_Number])<5,'0'& [ID_Number],[ID_Number) AS NTNAME,
UPPER(Group) AS GROUP
FROM
[..\xxx.xlsx]
(ooxml, embedded labels, table is Sheet1);
//
// USED FOR THE WHERE EXISTS CLAUSE IN THE SECTIONTEST TABLE BELOW
USERGROUPS:
LOAD
'AD\'& if(len([ID_Number])<5,'0'& [ID_Number],[ID_Number]) AS NTNAMEGROUP,
UPPER(Group) AS GROUP
FROM
[..\xxx.xlsx]
(ooxml, embedded labels, table is Sheet1); 

 

The User Group is the server side group would match with the NTNAME coming from the excel list.

marcus_sommer

What I see looked ok. Maybe there is anything else wrong. I think I would disable the section access and load the tables directly in the application so that you could check which data are really there and if the keys between the tables work.

- Marcus