Qlik Community

Qlik Sense Enterprise Documents & Videos

Documents & videos about Qlik Sense.

Column level access using Section Access

MVP & Luminary
MVP & Luminary

Column level access using Section Access

Hi,

This thread will helps in implementing the column level access. This can be done with Section Access and using Enable Conditional for Dimension in each chart.

Please find attached file for solution.

Login with below user IDs and no Password required :

A - Can see all the columns

B - Can see Sno column

C - Can see name column

D - Can see sno, name and dob columns

Try like this

Section Access;

LOAD * INLINE [

    ACCESS, USERID

    ADMIN, A

    USER, B

    USER, C

    USER, D

];

Section Application;

star is *;

UserColumnMapping:

LOAD

*

INLINE [

USERID,Secsno,Secname,Secdob,Seccity,Seccountry

A, 1,1,1,1,1

B, 1, 0,0,0,0

C, 0,1,0,0,0

D, 1,1,1,0,0

];

Data:

LOAD *

INLINE [

sno,name,dob,city,country

1,raj,1991,atp,india

2,kanna,1990,bnglr,india];

Note: You need to select Document Properties -> Opening tab -> and select Initial Data Reduction based on Section Access option



Regards,

Jagan.

Attachments
Comments
kkkumar82
Valued Contributor III

Hi Jagan,

This is a fine example, but I have small doubts(may be silly)

1. what is the use of star is *

2. How column names mapped for users because there is no association between usercolumnmapping table and data table.

0 Likes
kkkumar82
Valued Contributor III

Ok understood the association,

didn't observe the "enable" condition for the dimensions, but still what is the use of

star is *;

0 Likes
kkkumar82
Valued Contributor III

Hi jagan,

can we avoid section access screen I mean which asks for userid and password in access point because

any how we are going to give a authentication for access point and can we use the same userid for the section access.

Actually I tried it with NTNAME and  it is working fine in QV Desktop for different users(os users) but I dont know about access point.

Regards

Kiran Kumar

0 Likes
MVP & Luminary
MVP & Luminary

Hi Kiran,

I think for NTNAME only this works, otherwise you need to key in user ID and password.

From Qlikview Help file:

Star

The string specified is used to represent any values that may appear in a field, including NULL. It is used as a wildcard specifically for the QlikView application. It affects the subsequent Load and Select (SQL) statements. The syntax is:

star is[ string ]

where:

string is an arbitrary text. It can be a single symbolic character, such as an asterisk (*). The string must be enclosed by Quotation Marks in Scripting if it contains blanks

Note!
Star is old functionality. It can only be used for section access.

Restrictions:

  • The Star character is not accepted in info load files.
  • The Start character cannot be used in the key fields, the fields that link tables.

Examples of the Star statement:

Star is *;

Star is %;

Star is;

If nothing is specified, star is; is assumed; that is, there is no Star "wildcard" available. A string specified as the Star value is valid until a new star statement is made.

Example of Star string used in a Load script:

Star is ASTERISK

LOAD *

Inline [
Category, Place
Country, United States
City, London
Country, France
City, Paris
Country, Italy
City, Rome
Country, Spain
City, Madrid
ASTERISK, Monaco
ASTERISK, Vatican City
];

qlikviewnovice
Valued Contributor II

Nice Explanation!!

Arjunarao
Honored Contributor II

Nice post. Thank you for sharing this.

0 Likes
nihhalmca
Valued Contributor II

Useful information thanks for sharing Jagan.

0 Likes
nadeemsmarty
Valued Contributor

Hi Jagan,

Nice post !! I have one question here . Can this also be done using OMIT in section access or i am missing something .

Regards,

Nadeem

0 Likes
MVP & Luminary
MVP & Luminary

Hi,

You can also do the same using OMIT.  This have better flexibility.

Regards,

Jagan.

Version history
Revision #:
1 of 1
Last update:
‎2014-10-28 03:54 AM
Updated by: