Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Can I access the Locked/Protected User table or Reduction matrix table ?

Hi All,

Please give me some idea how can I access a excel table which

is protected.Is there any way to access it without knowing the userid

and password?What will happen when we will try to load that type of

table?Is qlikview will through some alert message?Please make me clarify.

Thanks & Regards,

Deep.

8 Replies
Highlighted

Can I access the Locked/Protected User table or Reduction matrix table ?

Hello,

As with almost any other source, you can use a ODBC entry in your system providing the username and password required to be granted access. If you don't know them you will not be able to open the file, as it would happen if you don't know your database user and password.

Hope that helps.

Highlighted
Not applicable

Can I access the Locked/Protected User table or Reduction matrix table ?

see this

http://community.qlik.com/forums/p/36844/166731.aspx

Highlighted
Not applicable

Can I access the Locked/Protected User table or Reduction matrix table ?

Thanks.

Highlighted
Not applicable

Can I access the Locked/Protected User table or Reduction matrix table ?

Thanks Mig.

If you help me one more time i will be grateful.Can we create a object level security?

Like

I want to show some charts or lists to some specific User depending on their

privileges.

Is it possible in Qlikview?please give me some demo or idea.

Thanks & Regards,

Koushik Roy.

GreenCube Infotech.

Highlighted

Can I access the Locked/Protected User table or Reduction matrix table ?

Hello Koushik,

Yes it's possible. I'd use section access for that, so depending on the user that is logging, some charts will or will not be displayed, or event entire sheets.

The idea, if you have several (say two dozens) users or more is create groups (in an external excel sheet, or in a table in the database, or a QVD file...) so the script is easy to modify, and use their membership in the conditional show using the Layout tab of the objects. A very basic example would be

Section Access; LOAD * INLINE [ACCESS, USERID, PASSWORD, GROUPADMIN, ADMIN, ADMINUSER, USER1, U1, SALESUSER, USER2, U2, HRUSER, USER3, U3, IT]; Section Application;


Now in the layout conditional, say you want the object to be displayed to HR and IT members

MATCH(GROUP, 'IT', 'HR') > 0


In case the user logged onto the document is USER1, this chart will not be visible.

Anyway, I'd group objects in sheets to show or display the whole sheet, instead of setting the conditional chart by chart.

Hope that helps.

Highlighted
Not applicable

Can I access the Locked/Protected User table or Reduction matrix table ?

Hi,

Did you tried searching this forum?

I remember, i have seen these kind of questions on this forum many times.

Try searching this forum from Google . you could try using serach as below

QlikView sheet level security site:community.qlik.com

- Sridhar


Highlighted
Not applicable

Can I access the Locked/Protected User table or Reduction matrix table ?

Dear Miguel,

If you have a demo of object level security please send me.

And for the above HR,IT example please send me a demo

where you can hide a chart and make visible depending on

user or group.

Waiting for your fast response.

Thanks & Regards,

Deep.

Highlighted

Can I access the Locked/Protected User table or Reduction matrix table ?

Hi,

Unfortunately I don't have time enough to create that application. Anyway I will not work, because I don't know your users, and the string to match must be the exact DOMAIN\UserName.

You should be able to do it yourself with the code I provided you above and the suggestions by the other users.

Regards.