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

[michaelneck]

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.

[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]

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