topic Re: How to control Section access Sub Tabs in a Sheet in QlikView

How to control Section access Sub Tabs in a Sheet

subbareddykm — Fri, 24 Jan 2020 02:22:35 GMT

Hi All,

hope you all good.

I'm trying to figure out the way, how to handle section access for sub tabs in sheet.

Example: I have Sales and Market as a sheet in my application with two sub tabs in each sheet.

what i want is If USER A goto Sales Sheet , he should see only Tab1 related data and if he goto Market sheet he should see Tab2 related data only.

Note : there is no connection for tabs and data filter in data, its only related to what we are showing in each tab.

Hope this clear. ref sample app in attachment

Regards,

Subbu

Re: How to control Section access Sub Tabs in a Sheet

rubenmarin — Sun, 26 Jan 2020 10:34:28 GMT

Hi, attached is one example of how you can do it.

You can access with User:ADMIN pass:ADMIN or User:A Pass:A

Check script and document propertis->On Open tab

Re: How to control Section access Sub Tabs in a Sheet

Brett_Bleess — Wed, 19 Feb 2020 21:25:17 GMT

Did Ruben's post and example assist you getting your use case working as you wanted? If so, please do not forget to return to your post and on Ruben's post, use the Accept as Solution button to mark that as the solution giving him credit for the help and to let other Members know this worked.

The only thing I have to add to what he has provided is a link to the Design Blog area to a post that will likely be able to further explain how to go about things, and I will include the base URL for you at the end in case you want to search that area further on your own.

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Section-Access/ba-p/1465766

Note, there are some additional links at the bottom of that post!

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett

Re: How to control Section access Sub Tabs in a Sheet

qliksus — Thu, 20 Feb 2020 08:08:11 GMT

You can create new field in section access like SheetTab and have the values filled accordingly

Acess,NTNAME,USER,PASSWORD,SHEETTAB

USER,*,A,A,SALESTAB1

USER,*,A,A,MARKETAB1

USER,*,B,B,SALESTAB2

USER,*,B,B,MARKETAB2

];

Use the if(not isnull(SHEETTAB) ,1) in the conditional hide in the button