Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Start with a field selection according to section access

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

15 Replies
Anonymous
Not applicable
Author

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

Anonymous
Not applicable
Author

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

gsbeaton
Creator II
Creator II

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.

Anonymous
Not applicable
Author

It's not making me any selections yet

Anonymous
Not applicable
Author

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

gsbeaton
Creator II
Creator II

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,'|')&')'