topic Re: Start with a field selection according to section access in QlikView

Start with a field selection according to section access

Anonymous — Wed, 16 Dec 2015 12:35:10 GMT

Dear community, I have a problem that I hope you can help me with.

I have the following section access

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, DEPARTMENT

ADMIN, ADMIN, ADMIN123

USER, USER, USER123, SALES

];

Section Application;

What I want to do, is that USER which can only access to the SALES Department, starts with this DEPARTMENT Selected.

Thank you very much

Re: Start with a field selection according to section access

tresB — Wed, 16 Dec 2015 12:43:51 GMT

When only one department is there in the scope, if selected or not - result would be same (assuming the conditional expression like - if(getselectedcount(... is not being there). Otherwise, you could try with OnOpen trigger ->Select in Field

Re: Start with a field selection according to section access

marcus_sommer — Wed, 16 Dec 2015 12:44:06 GMT

This won't be necessary then in this case no other data will be available.

- Marcus

Re: Start with a field selection according to section access

gsbeaton — Wed, 16 Dec 2015 12:45:51 GMT

You could do this with the OnPostReduceData() trigger found under Settings>>Triggers.

Add the SelectInField() action. Field will Be Department and Search string will be =concat(Department,'|').

I haven't tested that but in theory it should work, even if the signed in user has multiple distinct departments.

George

Re: Start with a field selection according to section access

awhitfield — Wed, 16 Dec 2015 12:47:04 GMT

Hi Francisco,

have you set:

See attached example

Andy

Re: Start with a field selection according to section access

Anonymous — Wed, 16 Dec 2015 12:47:23 GMT

I forgot to explain that I have lots of different DEPARTMENTS and more than one user

Re: Start with a field selection according to section access

gsbeaton — Wed, 16 Dec 2015 12:52:11 GMT

True, but I can see reasons why a designer may want a particular field to be selected, even if the data in scope remains the same, eg:

Usability, sometimes users need that comfort of seeing a particular field green
Functional: Maybe previous design has implemented a different chart to be displayed depending on what Department a super user selected. Selecting a department automatically upon datareduction completing would mean that no changes were required to legacy functionality.

George

Re: Start with a field selection according to section access

gsbeaton — Wed, 16 Dec 2015 12:53:30 GMT

Can a single user have access to more than one department?

Re: Start with a field selection according to section access

tresB — Wed, 16 Dec 2015 12:53:35 GMT

That's okay. You meant like:

LOAD * INLINE [

ACCESS, USERID, PASSWORD, DEPARTMENT

ADMIN, ADMIN, ADMIN123

USER1, USER1, USER123, SALES

USER2, USER2, USER123, IT

....

];

If so, USER1 will see only SALES whereas USER2 will see only IT. So, one department for each user would be visible. Perhaps, then you wouldn't have to select that single available department, right?

And if users could have multiple departments like:

LOAD * INLINE [

ACCESS, USERID, PASSWORD, DEPARTMENT

ADMIN, ADMIN, ADMIN123

USER1, USER1, USER123, SALES

USER1, USER1, USER123, IT

....

];

Try with OnOpen trigger as I suggested above.

Re: Start with a field selection according to section access

Anonymous — Wed, 16 Dec 2015 12:57:15 GMT

The thing is that I have lots of charts that as a dimension it considers all of the Departments, so, If I don't start with a selection, no matter which user is connecting, it will show the information of all the Departments even though I just want to show him just one.

Re: Start with a field selection according to section access

Anonymous — Wed, 16 Dec 2015 12:57:47 GMT

No, there's just one user for one Department. Only Admin has access to all

Re: Start with a field selection according to section access

Anonymous — Wed, 16 Dec 2015 13:15:09 GMT

It didn't work as espected. Indeed it started with the selection, but I don't know why the triggers I had didn't work

Re: Start with a field selection according to section access

gsbeaton — Wed, 16 Dec 2015 13:24:50 GMT

Hi Andrew,

That's not a very secure option. It means the user can see all departments (no data reduction happens) and (when working as designed) it sets an initial selection on the department the user has access to.

Re: Start with a field selection according to section access

Anonymous — Wed, 16 Dec 2015 13:36:33 GMT

It's not making me any selections yet

Re: Start with a field selection according to section access

Anonymous — Wed, 16 Dec 2015 13:39:39 GMT

That what's happend. The really cool thing would be to be able to select both options.

Re: Start with a field selection according to section access

gsbeaton — Wed, 16 Dec 2015 14:31:30 GMT

It may be that the concat is not quite right yet. I think it's looking for something like (Sales | Marketing | Finance) and at the moment we are excluding the brackets. Can you try with brackets, something like ='('&concat(Department,'|')&')'