Hide a tab for Users which are not Admin in the Dashboard

[kusha_2007]

Hello All,

I need to hide a tab in the qlikview dashboard for Users whose Access is not Admin.

I tried to use the column Access in the section file . 

Created one table with the column Access called USer_Access so that it joins with the Access column in the security table .

 I added a condition in the sheet properties to show for Access='ADMIN'. 

When I refresh the file , it opens in Qlikview Desktop but doesnt oopn in Access Point.

Please advise

Thanks 

Kusha 

[Vegar]

When opening an application in AccessPoint all user opens the app as USER regardless of which ACCESS is set in the Section Access definition. 

[kusha_2007]

Hello , 

I get an error : Failed to load document. You dont have access to this document 19 in Access Point.

Thanks 

Kusha

[Vegar]

You could create another field in a data island controlling the Dashboard presentation.

In your script add the followint to your data model.

LOAD * INLINE [

SA_DASHBOARD

TRUE

FALSE

];

In your Section Access add the SA_DASHBOARD and an value TRUE or FALSE.

Section Access:

ACCESS, NTNAME, SA_DASHBOARD

ADMIN, VEGAR, TRUE

USER, KUSHA, FALSE

In your tab show condition properties use 

=Only(SA_DASHBOARD= 'TRUE' 

[Vegar]

You might have locked your self out of the document. 

Do you have a backup copy?

[kusha_2007]

Hello Vegar,

I am able to access the document from the Qlikview Desktop.

Its not visible through Access Point. 

I have tried something  similiar to what you have shown but not working.

Created a inline table 

USER_ACCESS:
LOAD * INLINE [
FLAG_ADMIN
1
0
];

IN Security table Added a field FLAG_ADMIN=1 .Also, in The Document Properties--> Opening tab --> Initial Data reduction based on Access--> Strict Exclusion is enabled.

But still not working 

Thanks 

Kusha

if(UPPER(Trim(ACCESS))='ADMIN',1,0) as FLAG_ADMIN

Sheet Properties---> 

[kusha_2007]

Hello Vegar, 

I have done some analysis and based on that , it is picking the value from the first row in my security table .

Any idea why ?

Thanks & Regards,
Kusha

[Vegar]

It is a bit hard to adivice knowing only fragments of your Security setup. Could you please post your Section Access part of the script? (Or a simplified version of your section access part of the script)? 

I often find it helpful to temporary disable the section access of my applications in order to seek the answer to my SA problems. 

Try to disable the section access in your document properties and comment out the SECTION ACCESS; row in your script. By doing so you can examine how your SA looks like and maybe simulate how the SA will behave in you final application.

[Brett_Bleess]

Kusha, check out the following Design Blog post, in particular there are two dynamic reduction links at the bottom of the post to other blog posts, be sure to check those out as well, I think this along with what Vegar already explained, you may be able to get things working at that point.  

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

Regards,
Brett

[Arthur_Fong]

I am lost here.

Can you see the app in Access Point?

Two scenarios here:

1. You can see the app in Access Point, but locked with SA.

2. The app is not visible in Access Point.

Which is the one you are facing?