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: 
Not applicable

How to give access to different users to same qvw application

Hi,

I have one sales.qvw application with straight and pivot tables. I need to give access to sales.qvw file to users. But for user 1 one straight table, user 2 pivot table, user 3 pivot table and so on. How can I give access to different users to one sales.qvw so that they can able to see only their table. could anyone help me please.

Thanks.

16 Replies
Not applicable
Author

Thanks very much.

amars
Specialist
Specialist

As SALTO said Yes will need Document CAL's for each user. But for the developer no need of assigning an extra Doc CAL as the developer can always open it.

Thanks...

Not applicable
Author

Another way around would be creating a Section Access Table inside your QVW. I think this option could be better in the long term since scalability will be much easier to handle, also you will reduce the amount of calculations in the front end.

Not applicable
Author

Thanks and got it.

salto
Specialist II
Specialist II

Hello,

     If the goal is to hide data (and not objects) section access is the right approach. But as far as I know, the question was related to hide / unhide objects...

Regards!

salto
Specialist II
Specialist II

Glad to know. Please mark the question as answered, it will help other users.

Regards!

Not applicable
Author

I was thinking in adding FLAG fields into the SA Table, so you can add visibility conditions inside the charts..

SA_Table Example:

ACCESS, USERID, FLAG_CHART1, FLAG_CHART2

USER, User1, 1, 0

USER, User2, 0, 1

If you apply data reduction to the Document, section access will allow you to control objects visibility without conditions. (Ex: Condition inside the chart --> FLAG_CHART1=1)