Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
subbareddykm
Creator II
Creator II

How to control Section access Sub Tabs in a Sheet

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

3 Replies
rubenmarin

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

 

Brett_Bleess
Former Employee
Former Employee

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
qliksus
Specialist II
Specialist II

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