Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

More than one table in Section Application ?

Hi,

In my application, I got this to limit visibility to my users:

Section Application;

Visibilite:

LOAD

    IDSALARIE, Hash128(ICCOUT1,ICCOUT2,ICCOUT3,ICCOUT4,ICCOUT5,ICCOUT6,ICCOUT7,ICCOUT8,ICCOUT9,ICCOUT10,ICCOUT11,ICCOUT12,ICCOUT13,ICCOUT14,ICCOUT15) as keyVisibilite;

SQL execute get_salaries_vcc $(vIdClient);

That's working fine for limiting data in my app.

Now I have a new request: limit sheet access by user.

So, I would like to add a field "SHEETACCESS" wich contains "SALESGROUP", "HRGROUP", etc. and control for each field if the user connected is in a group that have the right to see the sheet.

Could you please tell me the best way to have this result?

1 Reply
IAMDV
Master II
Master II

Hi,

I'd suggest building a string for all the user names in the script. Something like this...

User_01 | User_02 | User_03 | ....... | User_100

Then you can use OSUser() function to show or hide the sheet object based on the OSUser() name. Something like this...

Match(SubField(OSUser(), '\', 2), vUserNameString) > 0

I hope this helps!

Cheers,

DV