Section access

[#1]

i have implemented section access for region wise....like this

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, REGION

ADMIN, ADMIN, ADMIN

USER, USER1, U1,AFRICA

USER,USER1,U1,AMERICA

USER,USER1,U1,ASIA,

USER, USER2, U2, AMERICA

USER, USER3, U3, AMERICA

USER, USER3, U3, ASIA

USER, USER3, U3, ASIA

];

Now my Question is why we need to write three times that USER1 FIELD....

CANT WE CREATE LIKE THIS

USER,USER1,U1, AFRICA OR AMERICA OR ASIA

thanks and regards

[hic]

Because the table is evaluated with QlikView logic. Logging on as USER1 is like clicking on USER1 and then you will be allowed to see the values that are possible in the REGION field.

But what you can do, is to load the data (within Section Access) as two tables:

HIC

[#3]

No We can't write this. Because, the region field will used to restict the values with the Region field in data model. If we use the values as 'A or B or C', it will try to join with the same text in region field.

[Peter_Cammaert]

Associations in QlikView are of type fixed-value-to-fixed-value. There is nothing like wildcards or conditional association ("maybe") available for linking tables & fields to each other. Probably because that would affect performance in a very bad way.

One exception: you can use * in section access to either indicate something like "anything will do" (for example in USERID or NTNAME fields) or to indicate "any value in this field is allowed" (in a field that links section access to section application).

Peter

[#5]

Hi henric thaks for ur response....

is there any way to do......i don't want write many times that user1 name

user1,[asia,america,africa]

[hic · Accepted solution]

Yes, you can use Subfield(). Example:

LOAD *,

     Trim(SubField(REGIONS, ';')) as REGION

INLINE

[ACCESS, USERID, PASSWORD, REGIONS

ADMIN, ADMIN, ADMIN, *

USER, USER1, U1, AFRICA;AMERICA;ASIA,

USER, USER2, U2, AMERICA

USER, USER3, U3, AMERICA;ASIA];

This will generate several rows - one per REGION - for each USER.

HIC

[#7]

thank you very much Henric....