Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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.
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
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]
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
thank you very much Henric....