Section Access on two fields

Thu, 06 Dec 2012 10:21:32 GMT

Hey,

I'm trying to reduce data by Section Access and I'm trying to figure out how to combine Section Access for two fields.

I have sports data and what I want is the following:

Every user is able to see top8 results from all countries, but every user is only able to see the full results from their own countries.

So far I've been able to let users only see the full results from their own country, but no results from other countries. And seperatly I've been able to let users only see a top8 of results but no 9th places f.e. for their own countries. But I have not managed to combine these two in the way I described above.

I got the restriction on countries working like this:

Star is ALL;

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, COUNTRY

ADMIN, ADMIN, ADMIN, ALL

USER, USER1, USER1, NETHERLANDS

USER, USER2, USER2, UNITED STATES

USER, USER3, USER3, BRAZIL

USER, USER4, USER4, RUSSIA

];

Section Application;

CountryData:

LOAD * INLINE [

COUNTRY, Country

NETHERLANDS, Netherlands

UNITED STATES, United States

BRAZIL, Brazil

RUSSIA, Russia

];

And I got the restriction on results working like this:

Star is ALL;

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, N_RANK

ADMIN, ADMIN, ADMIN, ALL

USER, USER1, USER1, TOP8

USER, USER2, USER2, TOP16

USER, USER3, USER3, TOP16

USER, USER4, USER4, TOP16

];

Section Application;

RankData:

LOAD * INLINE [

N_RANK, n_Rank

TOP8, 1

TOP8, 2

TOP8, 3

TOP8, 4

TOP8, 5

TOP8, 6

TOP8, 7

TOP8, 8

TOP16, 1

TOP16, 2

TOP16, 3

TOP16, 4

TOP16, 5

TOP16, 6

TOP16, 7

TOP16, 8

TOP16, 9

TOP16, 10

TOP16, 11

TOP16, 12

TOP16, 13

TOP16, 14

TOP16, 15

TOP16, 16

];

How can I combine these two to get the restrictions like I want them as desribed above in bold?

Any help would be greatly appreciated

topic Section Access on two fields in QlikView

Section Access on two fields