topic Need Help in QlikView

Need Help

pinky1234 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Team,

I have two sheets that is Sheet1 and Sheet2 in Single Qvw. Everyone should have access to sheet1, shouldn't ask for credentials or login details. I need to give access to Sheet2 only for specific people. Any thoughts please?

Re: Need Help

its_anandrjs — Sat, 14 Oct 2017 15:24:30 GMT

You have to go for Section access in your app then go for reading some of this for the help on section access.

Sheet Level Security.qvw

Section Access: Desktop vs Server

Chart Level Access

How to Distribute Dashboard and Implement Section Access

Re: Need Help

Anil_Babu_Samineni — Sat, 14 Oct 2017 16:02:37 GMT

Does your application opens Sheet 1 default? OR there is any activate sheet ??

Re: Need Help

pinky1234 — Sat, 14 Oct 2017 20:41:29 GMT

I have already implemented section access approach.I have given full access(Sheet1and Sheet2) to Admin and Sheet 1 only access to USER.When i login with admin he is able to see two sheets and when i login with user he is able to see only sheet1. Now my requirement is users(Couple of teams) should see Sheet1 with out asking login details (what i mean is it shouldn't prompt user details) Users should see sheet1 by default but Sheet2 should have restriction only couple of people of should see.Please find the attached Qvw for reference.Any thoughts on this?

When you try to open As admin you will see Sheet1 and Sheet2. When you try to open as user you will see Sheet1. Can i implement section access to only one sheet not to other sheets.

Re: Need Help

pinky1234 — Mon, 16 Oct 2017 12:40:24 GMT

Any thoughts?Please let me know if you have any questions.

Re: Need Help

pradosh_thakur — Mon, 16 Oct 2017 18:03:58 GMT

What if you use conditional enabling of sheet

something like

if OSUSER() OR QVUSER() = ' SOMETHING' OR 'SOMETHING1' for this ?

will this work for you?

regards

Pradosh