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

[ppereria]

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.