Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
Thanks Peter.
I found the solution after posting here.:)