Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
bharath8
Contributor II
Contributor II

section access reduction on island tbl

Hi All,

I have a island table in which i want to reduce the data.

My qlikview application has section access based on country and Sector, which is work perfectly on the main fact table. So when user login, the data is reduced on country/sector he is allowed to see.

My requirement is, in the new island table i want to reduce the data only by country field and wnat to keep the table as island(not linked to existing model).

Please help how to achive this.

1 Solution

Accepted Solutions
prieper
Master II
Master II

aircode:

SECTION ACCESS;

LOAD

*,

COUNTRY               AS ISLANDCOUNTRY;   

LOAD

NTNAME,

COUNTRY,

SECTOR

FROM ....

SECTION APPLICATION

In the facttable it will apply the combination of sector and country, in the Island-Table it will refer only to the indicated field.

Peter

View solution in original post

2 Replies
prieper
Master II
Master II

aircode:

SECTION ACCESS;

LOAD

*,

COUNTRY               AS ISLANDCOUNTRY;   

LOAD

NTNAME,

COUNTRY,

SECTOR

FROM ....

SECTION APPLICATION

In the facttable it will apply the combination of sector and country, in the Island-Table it will refer only to the indicated field.

Peter

bharath8
Contributor II
Contributor II
Author

Thanks Peter.

I found the solution after posting here.:)