topic Re: Section Access query in QlikView

Section Access query

Tue, 07 Aug 2012 07:24:07 GMT

Hi, I am new to qlikview and have a doubt with section access.

So, what i am looking for is a simple section access security with user id, password and OMIT options. I want a particular user to to view a certain fields.

To make it clear. Lets take an example.

I have a field called country which has 10 countries(US, GBR etc) as drop down. If I use OMIT in section access, i believe I can hide a particular field. In my case, if I omit country. the entire country field will be invisible. But, what I want is to omit a particular country from the field. ie: if i want to omit only GBR from the list of countries, how do I do it?

Can somebody help me with this?

Thanks in advance

Re: Section Access query

IAMDV — Tue, 07 Aug 2012 08:10:23 GMT

Hi,

You are right, using OMIT the User will not see the field. Rather you need to use Field reduction. Something like this...

SECTION ACCESS;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, COUNTRY

ADMIN, ADMIN, ADMIN,

USER, USER1, U1, USA

USER, USER2, U2, FRANCE

USER, USER3, U3, GBR

USER, USER3, U4, USA

USER, USER3, U4, FRANCE

USER, USER5, U5, *

];

Explanation :

USER1 will only see USA

USER2 will only see FRANCE

USER3 will only see GBR

USER4 will see everything except GBR (There are two rows in the above example, you need to add 9 rows in your case)

USER5 will see everything because I'm using "*" (Wild Card)

Please be very careful using the '*' (Wildcard) because it doesn't mean all the values in the Actual Field. It means distinct values you have specified in Section Access Table. Unless you have specified all the distinct values within Section Access.

In your Section Access example, you have specified Country values as {GBR,USA,FRANCE} but if your actual Country field contains{GBR,USA,FRANCE,GERMANY,INDIA,.....} then you won't see {GERMANY,INDIA,*****} rows even if the User has '*' in Section Access. It will ONLY take all the values from Section Access but not all the values from actual field.

I hope that makes sense.

I'm also attaching simple documentation on Section Access.

Good luck!

Cheers,

www.QlikShare.com

Re: Section Access query

Tue, 07 Aug 2012 08:11:01 GMT

post sample file:)

Re: Section Access query

Tue, 07 Aug 2012 08:15:00 GMT

Hi Deepak,

Thanks a lot for the explaination..Really helps.

Re: Section Access query

IAMDV — Tue, 07 Aug 2012 08:16:53 GMT

You're welcome. I'm planning to make series of video tutorials on Section Access and I'll update this thread once done. Please check QlikShare.com

Cheers,

www.QlikShare.com

Re: Section Access query

Tue, 07 Aug 2012 08:30:14 GMT

Hi deepak,

its weird. I tried the your method but unfortunately, its not working. Is there any particular setting I should be sure off?

Re: Section Access query

IAMDV — Tue, 07 Aug 2012 08:35:58 GMT

I think you need to turn on (Initial Data Reduction Based on Section Access). Please see the screenshot and also please check if you might need (Strict Exclusion) which is highly recommended. Please let me know if this doesn't work and make sure your COUNTRY field is in UPPER CASE.

Cheers,

www.QlikShare.com

Re: Section Access query

Tue, 07 Aug 2012 08:54:47 GMT

Hey, Its not working.. I am attaching a sample file..i need to restric the countries under cc unit.

Thanks

Re: Section Access query

IAMDV — Tue, 07 Aug 2012 08:56:20 GMT

That's strange but I'll look into it. I'm in transit and I'll get back to you soon.

Cheers,

Re: Section Access query

Tue, 07 Aug 2012 08:58:25 GMT

Yes, it is strange..

Thanks for your help

Re: Section Access query

Tue, 07 Aug 2012 09:00:08 GMT

Hi ,

I have posted a sample file.

Thanks

Re: Section Access query

IAMDV — Tue, 07 Aug 2012 11:58:12 GMT

Hi,

I can’t reload the document to test because you have the data from Excel Files. Although, I’ve noticed two things…

1. CC UNIT in Section Access should be CC Unit (Line 17 in your script)

2. Please use UPPER([CC Unit]) AS [CC Unit] (Line 25 in your script)

You need to make the Reduction field and Section Access Fields in UPPER CASE. Although, if you are using INLINE Load then QlikView implicitly converts them to UPPER CASE. But if you are loading from Excel / Databases / Other Sources then you need to make the field values in UPPER CASE.

Try this and let me know if this works…

Good luck!

Cheers,

http://QlikShare.com

Re: Section Access query

Tue, 07 Aug 2012 12:00:19 GMT

Hi,

Yes, I figured that out.. Its working now..

Thanks a lot for your help.

Re: Section Access query

Fri, 10 Aug 2012 11:25:27 GMT

Hi again Deepak,

I have a question, can section access be implemented on CORP (domain) login?

The idea is to avoid users from entering log in id and passwords.

please let me know if you can help on this.

Thanks

Re: Section Access query

IAMDV — Fri, 10 Aug 2012 11:28:59 GMT

Are you referring to the NTName? If yes then yes...

NTNAME

This field must contain a string corresponding to a Windows

NT Domain user name or group name.

QlikView will fetch the logon information from the OS and compare it to the value in

this field.

Example: DOMAIN\NTNAME

Cheers,

www.QlikShare.com

Re: Section Access query

Fri, 10 Aug 2012 11:58:04 GMT

So , when I use NTNAME, the script will be somethin like this.

Section Access;

Load * INLINE [

ACCESS, NTNAME

ADMIN, CORP\USER1

USER, CORP\USER2

] ;

Section Application;

if I want the user2 to view only a particular information (NA from the field CC Unit), so do I have to use the field reduction here? Also what about the password?

Re: Section Access query

Fri, 10 Aug 2012 12:33:38 GMT

Great..got it..

Thanks a lot

Re: Section Access query

manishnarang — Thu, 28 Feb 2013 07:38:05 GMT

Hi ztarique,

How did you get this work?

I am also trying to use DOMAIN\USERNAME thing, and it works fine on my machine (in different domains). But when i deploy it over server and access it using ACCESSPOINT, it again starts asking for Username and password.

Below is my code:

Section Access;
LOAD * INLINE [
    ACCESS, NTNAME, NTDOMAINSID, REGION
    USER, DOM1\MANISH.KUMAR2, S-1-5-21-4256075061-2164985111-xxxxxxxxx, AFRICA
    USER, DOM2\KUMMANI, S-1-5-21-3239103917-2504883716-xxxxxxxx, AMERICA
];
Section Application; SALES: LOAD * INLINE [ REGION, PROFIT AFRICA, 1000 AMERICA, 2000 ASIA, 3000 EUROPE, 4000 OCEANIA, 5000 ];

Please help!

Regards,
Manish Narang

Re: Section Access query

Marcoimp — Fri, 12 May 2017 15:55:38 GMT

Sorry,

I have the same problem.... could you please tell me how do you resolve it?

Thank you