topic Re: An issue with section access in QlikView

An issue with section access

Peony — Wed, 25 Nov 2020 16:16:04 GMT

Hi all!

Have an issue with section access.
I Set next:

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, UPPER(City) as CITY

ADMIN, ADM, 123, ROMA

];

Section Application;

So, when I opening document as this admin i should see only Roma. But still see all the cities in the list.
Please help to figure out what am I doing wrong?

Re: An issue with section access

olivierrobin — Fri, 13 Jul 2018 14:46:20 GMT

hello

are you sure of you load inline

isn't it

load

LOAD

ACCESS, USERID, PASSWORD, UPPER(City) as CITY;

load * inline [

LOAD * INLINE [

ACCESS, USERID, PASSWORD, City

in you load, you create a column named [UPPER(City) as CITY] which doesn't match with a column CITY

so no securty

Re: An issue with section access

vishsaggi — Fri, 13 Jul 2018 15:05:29 GMT

Your Field name City in Section access is different to City in our City table. Case sensitive issue. Can you try below:

Section Access;

LOAD ACCESS, USERID, PASSWORD, UPPER(CITY) AS CITY;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, CITY

ADMIN, ADM, 123, ROMA

];

Section Application;

Country:

LOAD * INLINE [

Country, Country_S

France, FR

Germany, GR

Italy, IT

];

City:

LOAD UPPER(City) AS CITY, Country_S;

LOAD * INLINE [

City, Country_S

Paris, FR

Marseille, FR

Berlin, GR

Hamburg, GR

München, GR

Köln, GR

Frankfurt am Main, GR

Roma, IT

Milano, IT

Napoli, IT

Torino, IT

];

Re: An issue with section access

passionate — Fri, 13 Jul 2018 15:23:27 GMT

HI Nataliia,

PFA, Solution.

Cheers,

Pankaj

Re: An issue with section access

Peony — Fri, 20 Jul 2018 07:12:26 GMT

Thank you for your help, Olivier.

Re: An issue with section access

Peony — Fri, 20 Jul 2018 07:13:55 GMT

Hi Vishwarath. It helps, I see my mistake. Thank you.

Re: An issue with section access

Peony — Fri, 20 Jul 2018 07:14:34 GMT

Hi Pankaj. Thank you much for your help.