Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

We value your feedback – take our 5-minute QlikView modernization survey
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

Need help with Section Access (value from multiple field).

I need your help about section access, I have data like this;


SKU       MODE           BRANCH
001        OFF                 8634
002        OFF                 8634
003        ON                  8000
004        ON                  8001
004        ON2               2005
005        ON2               2005


And I have section access like this;

USER        MODE        BRANCH
ALEX        ON                *
ALEX        OFF             8634
KIM           ON               *
KIM           ON2            *
MIKE        ON               *

What should to do next, create new field from MODE&'|'&BRANCH?

Because I've already created new field MODE&'|'&BRANCH? on Data Table and Section access table but It's not working.


Please help, I'm new here.


Many Thanks.


Labels (4)
2 Replies

 One thing to be aware of when using the Asterisk '*' is that it does not mean all values, it will only represent any values defined in that table.


Have a look at the following Design Blog post and note there are other links to other posts at the bottom of the link too, hopefully this will help explain things a bit more, but Lisa is correct as well.  With the setup you have, the only value all users are going to see is 8634, nothing else.  


Help link as well: http://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/Security.htm


To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.