Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Local/Total access

Dear All,

Is it possible to restrict a user's access (Section Access) to his departement but allow for an expression to place this local result next to the average over all the departements...?

Thank you in advance,

K

1 Solution

Accepted Solutions

Re: Local/Total access

Hi,

That's not possible, as Siri points out above. If you need to have reduced all information by department, but keep in one chart the total corresponding to all departments, you will need to first aggregate in the script the sum of all departments in a different field and add it (using JOIN likely) to each department line.

Then, although you reduce data, you will see the correct results.

Check the attached app just in case. Users are ADMIN, DEP1 and DEP2. For ADMIN you should see both depts and all data, and the sum of 100%. For DEP1 and DEP2 you should see each one's data, but the corresponding to the total.

Hope that helps.

Miguel

7 Replies
Not applicable

Local/Total access

Hi,

It is possible when we didn't use the reduce data in the server.

first create the application with all the separtments. By section access we can give the documents particular departments only.

Thanks

Siri

Not applicable

Local/Total access

Not sure I fully understand what you mean...

The idea is to have ONE document where someone from from departement A gets to see data filtered to departement A (no details for Dep B, C, D etc) but that he gets the average over all (A, B ,C and D)

I have a .qvw with the full dataset and section access limiting someone from Dep A to Dep A related data but then I can't put it into context by showing the average over all the departements...

Thank you for the quick response!!!

K

Re: Local/Total access

Hi,

That's not possible, as Siri points out above. If you need to have reduced all information by department, but keep in one chart the total corresponding to all departments, you will need to first aggregate in the script the sum of all departments in a different field and add it (using JOIN likely) to each department line.

Then, although you reduce data, you will see the correct results.

Check the attached app just in case. Users are ADMIN, DEP1 and DEP2. For ADMIN you should see both depts and all data, and the sum of 100%. For DEP1 and DEP2 you should see each one's data, but the corresponding to the total.

Hope that helps.

Miguel

Not applicable

Local/Total access

Thanks Miguel...

I am also trying your way.

Not applicable

Local/Total access

Dear Miguel,

This might indeed be the solution!

Thanks a lot!!

KR,

K

Not applicable

Re: Local/Total access

Dear Miguel,

I'm trying to write the script as you suggested, only, then I have to aggregate a Field based on several dimensions from different dimension tables.

How do you do this? Can you have more than one 'resident'?

Kind Regards,

Kevin

Re: Local/Total access

Hi Kevin,

Yes, you can do as many RESDIENT loads as you need. And you can also do a GROUP BY and use several fields instead of just one.

Hope that helps.

Miguel

Community Browser