Granting access to different data

[#1]

Hi, I have quite a difficult question for you all here.

I am creating a system for comparing live with budgeted data. It has the potential to be rolled out to lots of users, however each user will require access to different data sets.

At the moment I am loading the data and limiting it for demo purposes using a where clause, what I want to know though is whether I can have a table elsewhere that contains the users ID and Password that says when user ID = X load this where clause, so it will look like this:

LOAD

FIELD A

FIELD B

FIELD C

FIELD D

FIELD E

FIELD F

FROM TABLE Z WHERE (USER ID=DAVE, FIELD COLUMN, FROM TABLE1.DBO)

So......when dave is logged in he only sees certain values from FIELD A/B/C/D/E/F etc loading this information from another database, sorry this seems very complicated, but is it possible to do?

I assume this will have to be added into my GUI qvw and not the qvw that makes my qvd files initially.

Cheers

Ben

[prieper · Accepted solution]

Check the manual for access-restriction. Basically you can restrict each user to certain elements of each field.
There was just a thread under http://community.qlik.com/forums/t/23015.aspx

Peter