topic Re: Access Denied Message in QlikView

Access Denied Message

Fri, 11 Dec 2015 05:57:38 GMT

Hi All,

In the below image. I have access only to cashflow dashboard. When i click on Receivables. I will get a message on the screen(Admin Access Privelages). This is working as expected.

But when i click on Leads tab in the below image. It goes to the Leads tab and then will get a message on the screen. Problem here is it goes to the Leads tab and then will get a Message and closing on the message will have access to Leads tab.

Can someone tell me where is the mistake.

Regards,

Keerthi KS

Re: Access Denied Message

avinashelite — Fri, 11 Dec 2015 06:01:05 GMT

check with your conditional statements and variables once ...check on the click of close whether your action is getting set or not

Re: Access Denied Message

avinashelite — Fri, 11 Dec 2015 06:01:56 GMT

If possible share the file ...so that we can determine the exact issue

Re: Access Denied Message

Fri, 11 Dec 2015 06:11:44 GMT

Hi Avinash,

vCheckValidAccess=if((Sum(SH_Receivable))>0,1,0)----- Receivable Tab

vCheckValidAccess=if(Sum(SH_Leads)>0,1,0)------- Leads Tab

Re: Access Denied Message

tamilarasu — Fri, 11 Dec 2015 06:22:57 GMT

Hi Keerthi,

Check and modify the layout property according to your condition.

Re: Access Denied Message

Fri, 11 Dec 2015 06:25:24 GMT

Please find attached

Re: Access Denied Message

Fri, 11 Dec 2015 06:35:43 GMT

I am not using any Conditional. It shows all the time. I am using a variable for Roll based access

Re: Access Denied Message

tamilarasu — Fri, 11 Dec 2015 06:41:56 GMT

The screen is nothing but a textbox designed by someone (Guess someone not you). The conditional show is enabled as =vCheckValidAccess=0. See the below screenshot.

Both the labels contains same condition as

=if((Sum(SH_Receivable))>0,1,0).

Re: Access Denied Message

Fri, 11 Dec 2015 06:46:24 GMT

Hi Nagraj,

Can you send full screenshot. Its developed by someone else and i am modifying it currently.

Where was the condition shown ???

Regards,

Keerthi KS

Re: Access Denied Message

Fri, 11 Dec 2015 06:51:59 GMT

Hi Nagraj,

How to check the Access Denied Screen ?

I am not able to find it

Regards,

Keerthi KS

Re: Access Denied Message

tamilarasu — Fri, 11 Dec 2015 06:56:44 GMT

Hi Keerthi,

Right click on the sheet and click properties. You will see the below window. Go to objects tab and search the textbox which showing as "Condition: Hidden"

Modify the conditional show as per your requirement.

Re: Access Denied Message

Fri, 11 Dec 2015 07:04:52 GMT

Its the same condition for all the tabs. Conditions are working as expected. But the problem here is on click of Leads tab it goes to that sheet and then the Access denied message will be displayed.

It should show the message first

Re: Access Denied Message

tamilarasu — Fri, 11 Dec 2015 07:12:15 GMT

It will show the message, since the condition is Sum(SH_Leads)>0. So, the vCheckValidAcess is set as 1. As I already told you need to change the condition here (or If you don't want, simply remove these actions in LEADS label).

Re: Access Denied Message

Fri, 11 Dec 2015 07:20:05 GMT

Hi Nagraj,

I understand it shows the message. But it shows after going to Leads tab. But for me it should show before going to leads tab.

Re: Access Denied Message

tamilarasu — Fri, 11 Dec 2015 07:29:46 GMT

Fine. Simply, delete the activate sheet action (LEADS label).

Re: Access Denied Message

Fri, 11 Dec 2015 07:33:19 GMT

But sheet will not be activated when there is access.

Re: Access Denied Message

tamilarasu — Fri, 11 Dec 2015 07:43:11 GMT

Change the order like below and activate sheet expression as

=If(vCheckValidAccess=1,'Document\SH53')

Re: Access Denied Message

Fri, 11 Dec 2015 07:48:43 GMT

Still its behaving same way. Other tab works in different way. This tab works other way.

When i am in Cashflow tab and click on Leads tab. It will not go to the tab and then it displays message instead it should display message at the same screen(Cashflow Sheet) and display the Message.

Hope you understood my requirement.

Re: Access Denied Message

tamilarasu — Fri, 11 Dec 2015 08:01:41 GMT

Hi Keerthi,

Understood. Change the order for all the labels (activate sheet formula as =If(vCheckValidAccess=1,'Document\SheetId) as I mentioned earlier. I could not attach your sample, since the size is 9 MB. Could you check and let me know.

Re: Access Denied Message

Fri, 11 Dec 2015 08:04:07 GMT

Changed the order but its not working.