Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

How to control data access?

Hi All,

I have one scenario:

If I have the following data:

Region Revenue.

Brazil $100

France $200

Then there are two guys:A and B.

If A accesses the data, he only can see the Brazil and B only could see the France, how to control it? I can get their windows account.

Thanks.

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

How to control data access?

Hello,

A simple section access for what you are looking for would be as follows:

1.- First back your document up just in case something goes wrong

2.- Then create the following script at the beginning or at the end

STAR IS *; SECTION ACCESS; SectionAccess: // For example purposes being read from inline, any other valid source will workLOAD * INLINE [ACCESS, NTNAME, REDUCTIONADMIN, DOMAIN\ADMINISTRATOR, *USER, DOMAIN\A, AUSER, DOMAIN\B, B]; SECTION APPLICATION;ReductionTable:LOAD * INLINE [REDUCTION, REGIONA, BrazilB, France]; Data:LOAD Region, RevenueFROM Source


3.- Go to Settings, Document Properties, Open and check "Select data based on Section Access"

4.- Reload, close QlikView and open QlikView.

5.- If everything went fine, that is, your domain user credentials were passed on to the document, then you will see one of both regions selected. If that's the case, go back to Settings, Document Properties, Open and check instead "Reduce data..." and "Strict Exclusion".

6.- Close QlikView, open the document again and you should see only the records related to the user you are logged on (in my example DOMAIN\A or DOMAIN\B

Hope this helps.

4 Replies
Not applicable

How to control data access?

The feature you're looking for is "Section Access/Reduction" based on NTNAME

There is a very comprehensive guide here:

http://blog.qvapps.com/2010/06/10/introduction-to-qlikview-section-access/?utm_source=feedburner&utm...

Just make sure you make a backup copy of your app without section access as everyone locks themself out at least once

MVP
MVP

How to control data access?

Hello,

A simple section access for what you are looking for would be as follows:

1.- First back your document up just in case something goes wrong

2.- Then create the following script at the beginning or at the end

STAR IS *; SECTION ACCESS; SectionAccess: // For example purposes being read from inline, any other valid source will workLOAD * INLINE [ACCESS, NTNAME, REDUCTIONADMIN, DOMAIN\ADMINISTRATOR, *USER, DOMAIN\A, AUSER, DOMAIN\B, B]; SECTION APPLICATION;ReductionTable:LOAD * INLINE [REDUCTION, REGIONA, BrazilB, France]; Data:LOAD Region, RevenueFROM Source


3.- Go to Settings, Document Properties, Open and check "Select data based on Section Access"

4.- Reload, close QlikView and open QlikView.

5.- If everything went fine, that is, your domain user credentials were passed on to the document, then you will see one of both regions selected. If that's the case, go back to Settings, Document Properties, Open and check instead "Reduce data..." and "Strict Exclusion".

6.- Close QlikView, open the document again and you should see only the records related to the user you are logged on (in my example DOMAIN\A or DOMAIN\B

Hope this helps.

suniljain
Honored Contributor

How to control data access?

Suggestion given by Miguel is pefect . you have to implement section access based on Region Data.

chematos
Valued Contributor II

How to control data access?

Hola Miguel,

Puede haber algún problema para restringir el acceso a campos clave?

Estoy teniendo un problema con eso, con los demás campos me funciona todo correctamente.

Gracias, saludos.

Chema

Community Browser