topic Re: Section Access SQL in QlikView

Section Access SQL

Mon, 26 Jan 2026 18:19:17 GMT

Hello

Initially sorry for the language, but I am Brazilian.

I'm testing a QV with Section Access which works normally if I do the load through Load InLine, but when I load the data from Section Access via SQL it does not open, saying I have no access to the file.

Have I made sure that the SQL statement returns the same data EXACTLY Load InLine command. Has anyone gone through this problem?

Below is the example I'm testing:

Dont Work

SECTION Access;

SQL

Select 'ADMIN' as ACCESS,

            'Administrator' as NTNAME,

            '1' as LINK;

Work

SECTION Access;

LOAD * INLINE [

    ACCESS, NTNAME, LINK

    ADMIN, Administrator, 1

];

Help-me Please!

Re: Section Access SQL

Mon, 20 Jan 2014 13:48:20 GMT

Discovered!

When performing the load via SQL users need to convert user names to uppercase, with the function UPPER

Descobri!!!

Ao realizar a carga dos usuários via SQL é preciso converter o nome dos usuários para letras maiusculas, com a função UPPER

Re: Section Access SQL

Mon, 20 Jan 2014 13:52:44 GMT

Hi Anderson,

You must change them to upper case to work in section access, because section access allows only uppercase data as per qlikview standards.

thank you.