Show all rows on Section Access

[Anonymous]

Hello all,

I have a dataset like this:

ID	Department	Salary
1	A	1000
2	A	2000
3	B	3000
4	C	4000
5	D	5000

The idea is each one connected from different  department to be able to see only salaries of his department. For example someone from department A should see this:

ID	Department	Salary
1	A	1000
2	A	2000
3	B
4	C
5	D

I used a hidden script with section access,that filters on the field 'Department' but unfortunately I get this:

ID	Department	Salary
1	A	1000
2	A	2000

So, as you understand, I want also to have the rest of the columns, but the salary to be hidden.

I tried creating 2 different tables like:

ID	Department2
1	A
2	A
3	B
4	C
5	D

AND

ID	Salary
1	1000
2	2000

and merge them but it doesn't work. I suppose there is a problem synthetic keys. Thanks a lot in advance!!!

Michael

[Peter_Cammaert]

If you do not want to filter on Department but want to drop the facts associated with those departments, then what do you want to show in your QlikView tables and objects about these departments?

Remember that QlikView by default hides all dimension values that have nothing to show for themselves from every table and from all objects that don't have Show All Values set (or suppress Null values disabled)