Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi ,
I have posted a sample file.
Thanks
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
Hi,
Yes, I figured that out.. Its working now..
Thanks a lot for your help.
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
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
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?
Great..got it..
Thanks a lot
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
Sorry,
I have the same problem.... could you please tell me how do you resolve it?
Thank you