Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
michaelneck
Contributor II
Contributor II

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
MVP & Luminary
MVP & Luminary

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 II
Contributor II

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
MVP & Luminary
MVP & Luminary

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