Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

proctors
Contributor

Compare User Data to Other Users when using Section Access

Hi.

We have a physician scorecard that shows individuals their own performance data and only theirs by using Section Access. However, we now want to compare their data to their colleagues (de-identified). SA restricts all other user data by design. How should I restructure my data to make it so that I can compare the logged in user to their colleagues, without them knowing the names of those comparison colleagues?

4 Replies

Re: Compare User Data to Other Users when using Section Access

Hi, supposing the de-identified data is in another table you can relate each user with each other user of this new table. This can be done joining all users and removing the one that links with the current user, like:

JoinTable:

LOAD IdUser Resident UsersTable;

Join LOAD IdUser as IdOtherUser Resident UsersTable;

FinalTable:

NoConcatenate LOAD * Resident JoinTable Where IdUser<>IdOtherUser;

DROP Table JoinTable;

proctors
Contributor

Re: Compare User Data to Other Users when using Section Access

No, it's just one table. I'm concerned about basically having to duplicate the table.

datagrrl
Contributor III

Re: Compare User Data to Other Users when using Section Access

I struggled with something similar recently. In all honesty the only solution that comes to me is what Ruben said.

I don't see an option that doesn't duplicate the tables, or at least the data you want to be able to compare. The only other option I see is one giant table where you repeat the data for all other doctors for each doctor, but that doesn't seem like the most efficient data model.

Re: Compare User Data to Other Users when using Section Access

And if it's in the same table, how it's de-identified?. In that case seems all data is identified and maybe you only need to apply set analysis in expressions to compare user data with other users data.