topic Security from Excel in QlikView

Security from Excel

Mon, 26 Jan 2026 18:19:17 GMT

Hi all,

we have a security list in excel which contains the names from users who have access.

If we try to load the excelfile in the Section Access, it loads. But when we try out the security, it prompts and asks for a user id (its NT security)

If we do the same values in a inline table, it works perfect.

Also, if we put the values from the inline table to an excel export file and load that exportfile to the section access it works perfectly.

My question is: what are the settings in an excel document for section access? is it the fieldproperties we have to adjust or is it something else?

In the excelfile we use the following fields:

ACCESS, USERID, PASSWORD, NTNAME, NTDOMAINSID, PROFILE_1, NTSID, PROFILE_2

the PROFILEs are the accessiblilty for data redundancy.

Does anybody know the answer?

Thanks in advance

Rey-man

Security from Excel

Bjorn_Wedbratt — Mon, 11 May 2009 14:44:17 GMT

Hi Rey-man,

Shouldn't be any differences. I load SA from xls all the time. The only thing I can think of is that you don't have strict CAPITAL letters in you xls. Remember that both fieldnames (NTNAME etc) and field value (USER1, USER2 etc) should be in capital letters. As a good practice always format your fields with the upper() function, like

Load upper(NTNAME) as NTNAME,

upper(PROFILE_1) as PROFILE_1)

and so on.

Security from Excel

Mon, 11 May 2009 14:49:55 GMT

Hi Bjorn,

thanks for your reply.

I forgot to mention that we put the Upper() statement in our xls

The fieldnames are indeed NTNAME (capitalized).

So its really strange that it doesn't work.

Rey-man

Security from Excel

Bjorn_Wedbratt — Tue, 12 May 2009 03:01:36 GMT

If possible, can you post an example xls-spreadsheet? This must simply be a small typo somewhere, because as I said, there's nothing special related to reading SA info from xls.

Security from Excel

Tue, 12 May 2009 13:30:29 GMT

The problem is solved.

It required a * with the USERNAME and PASSWORD in the Excel file

Rey-man