Discussion Board for collaboration related to QlikView Deployment.
I have a requirement that needs to implement Session Access by Field name let say "CITY" i need only few user see all the city's data rest need to see few..
Here is the script that i used but no success.
(ooxml, embedded labels, table is [Authentication]);
LOAD * INLINE [
B, B C, C D, D E, E F, F G, G H, H I, I J, J K, K L, L M, M N, N O, O P, P Q, Q
AM attaching the XL file that i used.please help me with this.
You need to use a separate line for each city in the section access table. Comma separated strings will not be matched with individual city values in the application tables.
SubField(CITY, ',') as CITY
(ooxml, embedded labels, table is [Qv Authentication]);
* in section access is for all listed values, not for all values
Thanks for your reply,what should i used to let some users to see all the subfilelds inside the CITY.
Thanks for your reply,Can you please share the exact script as am new i am unable to get it.
Adding a user record with * in the city column will allow that user to see all cities that exist in the Section Access table.
marcus_sommer has put together a good post with links to many items on Section Access. This should give answers to your questions. Section Access
Thanks you maxgro,perfectly working.