topic Re: QlikView Section Access - Tab show/hide based on a condition in QlikView

QlikView Section Access - Tab show/hide based on a condition

ppereria — Sat, 16 Nov 2024 21:01:57 GMT

QlikView - Section Access - Restrict data as well as maintain sheet Show hide

Hi All,

I have to develop 2 part of Section Access - One based on Data restrict data, and the other show hide the tab based on logged in User.

Section Access restricting data is working fine.

I am unable to develop Tab show hide - What I want to do is -

1. if user is admin - he should see all the city data and view all the tabs too - Tab names Tab1, Tab2, Tab3, Tab4.

2. if user has access to one city like London - Dashboard to show up only London data but should also restrict showing 2 tabs out of 4 - say tab3 and tab 4 should be hidden.

3. if user has access to 2 cities like London and Chicago, then user should see data pertaining to these too, but should also restrict showing tab3 and tab 4

Currently even an admin when selects a particular city QV is hiding the 2 tabs. Which it should not, no matter what I click all the tabs should be visible.

Re: QlikView Section Access - Tab show/hide based on a condition

saminea_ANZ — Wed, 17 Apr 2019 09:07:02 GMT

What is there in the tabs? Does it holds reports with data?

Re: QlikView Section Access - Tab show/hide based on a condition

ppereria — Wed, 17 Apr 2019 09:53:17 GMT

yes, it holds data. This should be viewed only by admin.

Re: QlikView Section Access - Tab show/hide based on a condition

HirisH_V7 — Wed, 17 Apr 2019 10:08:05 GMT

you can create a Section Access table like this,

SA_User	DataLevel	Tab 1	Tab 2	Tab 3
Admin	*	*	*	*
User1	Reg 1	1	0	0
User2	Reg 2	0	0	1
User3	Reg 3	0	1	0

Above table will define, who gets to see what. Under tab fields, 0 means user will not have access that area.

In UI at Sheet level or object level layout condition:

Tab 1<>1 for tab 1 ... similarly for others.

Hope this will work.

Re: QlikView Section Access - Tab show/hide based on a condition

Brett_Bleess — Wed, 29 May 2019 18:52:15 GMT

Here is a link I have left on a few other posts now from the Design Blog area by Henric Cronstrom, there are additional blog post links at the bottom of that post with information on related topics, which may help you get things sorted out.

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

Regards,
Brett