Section Access query

[#1]

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

[#2]

Hi ,

I have posted a sample file.

Thanks

[IAMDV]

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,

DV

http://QlikShare.com

[#4]

Hi,

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

Thanks a lot for your help.

[#5]

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

[IAMDV]

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,

DV

www.QlikShare.com

[#7]

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?

[#8]

Great..got it..

Thanks a lot

[manishnarang]

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

[Marcoimp]

Sorry,

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

Thank you