Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I would like to apply the section access in qlikview.
The requirement is different user with different data with specific prefix letter
Access | UserID | Password | FIELD |
ADMIN | A | 1234 | * |
USER | B | 1234 | HK* |
USER | B | 1234 | ABC |
USER | C | 1234 | CN* |
How to apply the section access like HK*?
User B will able to access the data with prefix letter HK and ABC
User C will able to access the data with prefix letter CN.
Best Regards,
Louis
Any idea on it?
May be try thi
Column level access using Section Access
Hi Anil,
Thank you for reply.
The post you shared is for column level security.
Seems is different with my case.
Best Regards,
Louis
Any idea on it?
Hi,
Try this,
Also refer my sample attachment,
SECTION Access;
LOAD * INLINE [
COUNTRY, USERID,PASSWORD,ACCESS
INDIA, DEVA,ADMIN123,USER
SINGAPORE, RAM,ADMIN123,USER
*,ADMIN,ADMIN45,ADMIN
];
SECTION Application;
Fact:
LOAD * INLINE [
COUNTRY, SALES
INDIA, 1000
SINGAPORE, 2000
MALAYSIA, 3000
INDONESIA, 5000
];
Hope this helps
Regards,
Deva
Requirement was not with define data I guess
What ever country starts with IN* all countries the user should be able to see.
Hi,
Please find attached the app.
I think this is what you need.
Best regards,
Cosmina