topic Re: How to set variables in section access? in QlikView

How to set variables in section access?

Fri, 13 Sep 2013 13:40:40 GMT

I have created my section access like below. I need to know how to set a variable in section access and value will be different for each user.

I will be using this value to evaluate while logging in and will display or hide some functionality to that user.

Section Access;
LOAD * INLINE [
    ACCESS, USERID, PASSWORD
    ADMIN, ADMIN, ADMIN
    USER, USER1, USER1,
    USER, USER2, USER2
];

Thanks,

Re: How to set variables in section access?

marcus_sommer — Fri, 13 Sep 2013 13:50:36 GMT

Not really sure what you want achieve with these variables - variables have at one time always one value. Perhaps this is helpful for you: Introduction to Section Access

- Marcus

Re: How to set variables in section access?

Fri, 13 Sep 2013 14:26:43 GMT

I believe you are looking for some like the attached. You just need to add an additional field to your section access and then use this to drive a 'variable' (within the second table) which is used in the Conditional show of the sheets (or anywhere else the conditional show functionality exists or use it to drive a flag).

The code is as follows;

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, SHEET

ADMIN, ADMIN, ADMIN, MS

USER, ADMIN2, ADMIN2, SS

];

Section Application;

Profile:

Load * INLINE [

SHEET, ThisRole

MS, 1

SS, 0]

;

Let me know how you get on, but I think this is the correct answer - am I right?

Regards

Steve

Re: How to set variables in section access?

Fri, 13 Sep 2013 15:13:40 GMT

Thanks for your reply.

Basically, I want to restrict display of few buttons in my applications based on the type of user logging in.

So, I am planning to display the button if the variable value corresponds to that particular user.

As you mentioned, I want to have constant value for that variable that determines the type of user logging in.

Re: How to set variables in section access?

Fri, 13 Sep 2013 15:23:18 GMT

Steve, thanks for your reply.

This looks to be something similar. But as I mentioned before.

I want to restrict displaying Buttons in my applications based on the type of user logging in.

This seems to be for displaying sheet.

Also, I don't see a conditional display for the text box. So, how it is identifying which user is logging in?

I guess you are having two sheet one for admin and another for admin2.

Re: How to set variables in section access?

marcus_sommer — Fri, 13 Sep 2013 15:26:21 GMT

You could use for this in the visibility-condition from the buttons:

if(osuser() = 'x', true()) or if(qvuser() = 'x', true())

If there are many users you could also extend these expressions with a pick(match()) or you checked only parts from the user-id with string-functions.

- Marcus

Re: How to set variables in section access?

Fri, 13 Sep 2013 15:43:30 GMT

I've slightly changed my example. The Conditional Shows are available in several places, as described below;

Sheet > Sheet Properties > Show Sheet - Conditional

Text Objects > Properties > Layout Tab > Show - Conditional

Buttons> Properties > Layout Tab > Show - Conditional

To assign the users which button, you need to create an additional field. In my example, I have created SHEET. Therefore, should the users role be ADMIN sheet needs to be MS (or any other code you wish) and USER is SS (or again a code of your choosing).

These codes are used within the Profile Table (as Section Access fields cannot be used directly in your model as they are hidden). Thus we have "ThisRole" of 1 (for ADMIN) or 0 (for USER).

I have created two buttons, one for Role 1 ("ThisRole" = 1) and Role 0 ("ThisRole" = 0). For Role 0, Under the Layout tab for the button I have entered the formula 'ThisRole = 0' which means unless your Role is 0, you will not see the button.

Does that make sense? Let me know if you would like me to elaborate more or if this fixes it.

Steve

Re: How to set variables in section access?

Fri, 13 Sep 2013 17:01:11 GMT

Ok, I got what you are saying.

For the section access below, I gave " if(QVUser()='ADMIN', true()) " in the both enable condition and in the layout condion for the button that I need to restrict. But when I logged in as "USER1", I am still able to see the buttion I added the condition.

Is there something I am missiong?

Section Access;
LOAD * INLINE [
    ACCESS, USERID, PASSWORD
    ADMIN, ADMIN, ADMIN
    USER, USER1, USER1,
    USER, USER2, USER2
];

Thanks,

Re: How to set variables in section access?

marcus_sommer — Fri, 13 Sep 2013 19:08:43 GMT

Put qvuser() and osuser() in a textbox and you could see what qv returns and change your conditions - qvuser() returns only a value if section access with all required settings enabled and osuser() contains also the domain like domain\user.

- Marcus

Re: How to set variables in section access?

Fri, 13 Sep 2013 19:29:04 GMT

Did you look at my second qvw example? Is this what you are looking for? You set the variable in the section access code and then when you log on as either ADMIN or ADMIN2 (I've set Admin2 up as a user) with same password as username, you will see a button. If you log in as other user, you will see another button. These are separate buttons which are viewable depending upon the ThisRole field which is dependent upon the SHEET field in section access. The hide button calculation is under the layout tab of the buttons properties.

SImple enough yeah? Let me know of you need any more information.

Steve

Re: How to set variables in section access?

Fri, 13 Sep 2013 19:39:17 GMT

Hey Steve,

Thank you very much for following up.

I did see your example. I can understand you have two users.

1) Admin with Admin Access

2) Admin2 with User Access

am not sure what your are referring as sheet in the "Section Access" and I am not sure why do we need to use it?

And in the "Section Application", you are assigning a role value for each sheet.

Is it not possible to assign the role value in the "Section Access" it self? Why do we need to go for another step?

I will look for a possible way having your example as base.

Re: How to set variables in section access?

Fri, 13 Sep 2013 20:16:39 GMT

Sheet could be called anything, it's just a field to indicate a certain level of authorisation, as defined below. It's not necessarily per sheet, the name I've used clouds the solution. SHEET is just a field, it could be sales area, department, xxx, anything, whatever makes sense for you...call it button?

I use the two steps for two reasons;

1) This allows for more complex and sophisticated scenarios, the example is a simple one.

2) I'm not sure just doing this in one step works. The section access is all hidden once a user accesses the report which means the field you need disappears. But try this and let me know if one step works.

Let me know how you get on and let me know if you have any questions.

Steve

Re: How to set variables in section access?

Mon, 16 Sep 2013 14:49:31 GMT

I was wondering, did the above prove to be correct and solve your issue. I hope it proved useful at least.

Let me know if you need it clarifying.

Steve

Re: How to set variables in section access?

Mon, 16 Sep 2013 14:58:05 GMT

Hi Steve,

Your example was really helpful and in fact, I tried something similar for my logic and it worked.

But my only issue here is, it is forcing me to create a separate table (to map section access users and their roles).

As I said before, there should be a way with the section access table alone. But I am yet to figure out appropriate solution for that. I will let you know once I derive that.

Thanks much for your help.

Thanks,

Raghuraman

Re: How to set variables in section access?

Mon, 16 Sep 2013 15:37:30 GMT

Steve,

I am finding an issue with your approach.

Below is the script I added for Section access and additional table for role_number

For User1 and User2, I have uncheck "Edit Script" options in tab "Settings" - > "Document Properties" -> "Security".

But still I am able to see the edit script icon in the tool bar and in the File menu options.

This is allowing User1 and User2 to edit the script if they can.

Do you know how to disable "Edit Script" icon for User1 and User2?

Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD, ROLE
    ADMIN, ADMIN, ADMIN, AD
    USER, USER1, USER1, US1
    USER, USER2, USER2, US2
];

Section Application;

Profile:
Load * INLINE [
ROLE, ROLE_NUMBER
AD, 0
US1, 1
US2, 2
];

Re: How to set variables in section access?

Mon, 16 Sep 2013 15:48:10 GMT

I'm not at my machine at the moment but, as memory serves, you will find this setting under Document Properties > Security.

However, I'd really recommend that you move this script to a hidden tab that is password protected to ensure your security model cannot be compromised. (In your script go to file > create hidden script and enter a password twice).

Regarda

steve

Re: How to set variables in section access?

Mon, 16 Sep 2013 17:04:35 GMT

I did that in the Documents Properties and unchecking the Edit Script option for USER.

But I am still able to see the icon when loged in as USER.

Hidden Script is an option to hide the section access, which I am doing now.