Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Section access

Hi experts,

I am using NT security for Section Access:

Section Access;

LOAD * INLINE [

ACCES, NTNAME, ACCESS_REGION_CODE

ADMIN, XXX-INTRA\QLICKVIEW

ADMIN, XXX-INTRA\PETER

USER, XXX-INTRA\PROD_CHINA, CHINA

USER, XXX-INTRA\PROD_ASIA, ASIA

USER, XXX-INTRA\PROD_EUROPE, EUROPE

USER, XXX-INTRA\PROD_JAPAN,  JAPAN

Section Application;

star is *;

LOAD * inline [

Region, ACCESS_REGION_CODE

*, ALL

CHINA, CHINA

ASIA, ASIA

EUROPE, EUROPE

JAPAN, JAPAN

];

How to hide same objects for regional users (CHINA, JAPAN) and how to hide same objects for market users(ASIA, EUROPE)?

Thank you for your answer.. 

1 Solution

Accepted Solutions
felipe_dutra
Partner - Creator
Partner - Creator

hi!

Attached is a demonstration of section Access.

Use different userid to see which data are presented.

    ACCESS, USERID, REDUCTION

    ADMIN, ADMIN

    USER, USER, *

    USER, USER1, 1

    USER, USER2, 2

    USER, USER3, 3

    USER, USER4, 4

    USER, USER5, 5

    USER, USER6, 2

    USER, USER7, 6

View solution in original post

7 Replies
Not applicable
Author

Hey Gabriela,

You can use osuser() function in Conditional show/hide feature in the objects to control who sees which objects.

You can also just use the field name like

Access_Region_Code = All in conditional show

So only when Admin enters it will display the object.

Thanks

AJ

Not applicable
Author

Use can also use Chart show condition in Layout tab of charts.

eg :

regioncode = 'CHINA' or 'JAPAN'

Not applicable
Author

Thank you guys for yours answers.

Not applicable
Author

In the section of access, the user repeats so you can have two or more values

Section Access;

LOAD * INLINE [

ACCES, NTNAME, ACCESS_REGION_CODE

ADMIN, XXX-INTRA\QLICKVIEW, *

ADMIN, XXX-INTRA\PETER, *

USER, XXX-INTRA\PROD_ASIA, ASIA

USER, XXX-INTRA\PROD_ASIA, THAILAND

USER, XXX-INTRA\PROD_JAPAN, JAPAN];

felipe_dutra
Partner - Creator
Partner - Creator

hi!

Attached is a demonstration of section Access.

Use different userid to see which data are presented.

    ACCESS, USERID, REDUCTION

    ADMIN, ADMIN

    USER, USER, *

    USER, USER1, 1

    USER, USER2, 2

    USER, USER3, 3

    USER, USER4, 4

    USER, USER5, 5

    USER, USER6, 2

    USER, USER7, 6

Not applicable
Author

Hi,

thank you for your response. It is very helpful document. 

jpk
Partner - Creator II
Partner - Creator II

Hi Everyone

Really great post, most appreciated.

Ebiexperts a Qlik Technology partner has launched an automated Section Access product to the market. 

The product is called SAM: Section Access Manager for Qlik

  • Qlik Integrated & Authenticated
  • Self-service no-code
  • Automation options
  • Active Control SingleTouch
  • Admin
  • E-Learning

This is the MVP release and fully automated. I have attached the brochure.

Regards

JP