topic Re: Handling many tabs - Pick list using a multi-box in QlikView

Handling many tabs - Pick list using a multi-box

Anonymous — Mon, 14 Dec 2015 15:45:04 GMT

I am handling many tabs in my QV application with the following list box:

Within the sheet properties i have a conditional show based on the following expression:

=Match(QVUser(),'CHITEMERERE CHRIS') and if(GetFieldSelections(_View) = 'Patent Analytics', True(), False()) and user selecting the sheet to view from the multi box.

The fist part of the application limits sheet access to user 'CHITEMERERE CHRIS'. If however another user with no access rights to the 'Patent Analytics' sheet selects 'Patent Analytics' in multi box depicted above, the application opens a tab which contains all the fields in my application which is as follows:

How can the application be configured to avoid this behaviour, say going to a default sheet like the 'Dashboard' or any other recommendations?

Re: Handling many tabs - Pick list using a multi-box

prieper — Mon, 14 Dec 2015 16:48:05 GMT

can you post an example please?

seems to me that there might be a misspelling.

Peter

Re: Handling many tabs - Pick list using a multi-box

Peter_Cammaert — Mon, 14 Dec 2015 16:55:13 GMT

Is this a continuation of the same disucssion as the end of the previous one: Section Access Simplification‌ ?

If so, please close the other one or we're bound to loose track. Thanks.

Re: Handling many tabs - Pick list using a multi-box

Mon, 14 Dec 2015 16:56:55 GMT

suggestion - I have used the Upper(OSUser()) function in a variable or variables, where I will set the variables based on the user logged in - the tab will then only show if the user that loggs in matches a name defined in the variable. This sounds similar to what you are doing

My main question is the business/use case for the lsit box containing all of the sheets?

If there are no concitions around the values in the list, then all users will see all tabs that are in the applciation, even if they do not have access

Re: Handling many tabs - Pick list using a multi-box

Anonymous — Mon, 14 Dec 2015 17:54:03 GMT

Thank you Adam, the business/use case for the multi box is that the number of tabs is too many and cluttering the user interface. Hiding the tabs and using a multi box gives a more appealing user interface.

can you explain further the use of the Upper(OSUser()) function

Re: Handling many tabs - Pick list using a multi-box

Anonymous — Mon, 14 Dec 2015 17:54:30 GMT

Many thanks, closed and marked as assumed answered

Re: Handling many tabs - Pick list using a multi-box

Mon, 14 Dec 2015 18:04:23 GMT

what I have done is defined a variable that calls the function. The function checks the user name, including the domain and if they match, I set a variable.

I then have a conditional show on the tab that will only show the tabs based on what the user has access to.

I find it easier to manage than section access

=if (UPPER(OSuser())=domain\user1'
or UPPER(OSuser())=domain\user2'
or UPPER(OSuser())=domain\user3'
,1,0)))

The avove checks the name and sets the variable to 1 if the user that logs in matches a user in the list. The show condtion on the tab will show only if the variable is set to 1

You can have multiple different values, almost like user roles where the variable of 1 is the lowes, and 10 is the highest

you would have multiple if tests like above and then the show contition would be based on the values

Re: Handling many tabs - Pick list using a multi-box

Mon, 14 Dec 2015 18:26:34 GMT

also, in accesspoint, if there are enough tabs to scroll, over on the right is a down arrow that when clicked, will show all of the tabs in the application

Re: Handling many tabs - Pick list using a multi-box

Anonymous — Mon, 14 Dec 2015 18:50:34 GMT

Many thanks Adam for the two recent posts and input

Re: Handling many tabs - Pick list using a multi-box

Mon, 14 Dec 2015 19:16:52 GMT

christoper - If you open your applciation either on accesspoint or on your desk top and seitch to web view, you will see a down arrow next to the left and right arrows - if you select it you should see a list of all of the tabs available (below is a sample but had to erase the name of some entries, but it should give you an idea)

Re: Handling many tabs - Pick list using a multi-box

Anonymous — Mon, 14 Dec 2015 20:16:26 GMT

Thanks Adam