topic Re: Section access in QlikView

Section access

Tue, 08 Sep 2015 07:44:44 GMT

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

];

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

Re: Section access

hic — Tue, 08 Sep 2015 07:52:53 GMT

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

Re: Section access

Tue, 08 Sep 2015 07:53:17 GMT

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.

Re: Section access

Peter_Cammaert — Tue, 08 Sep 2015 08:02:32 GMT

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

Re: Section access

Tue, 08 Sep 2015 08:18:11 GMT

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]

Re: Section access

hic — Tue, 08 Sep 2015 08:22:21 GMT

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

Re: Section access

Tue, 08 Sep 2015 14:37:35 GMT

thank you very much Henric....