Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Peony
Creator II
Creator II

An issue with section access

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?

1 Solution

Accepted Solutions
vishsaggi
Champion III
Champion III

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

];

View solution in original post

6 Replies
olivierrobin
Specialist III
Specialist III

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

vishsaggi
Champion III
Champion III

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

];

View solution in original post

passionate
Specialist
Specialist

HI Nataliia,


PFA, Solution.

Cheers,

Pankaj

Peony
Creator II
Creator II
Author

Thank you for your help, Olivier.

Peony
Creator II
Creator II
Author

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

Peony
Creator II
Creator II
Author

Hi Pankaj. Thank you much for your help.