Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Security - Dynamic Data Reduction

Hi,

I am referring to chapter 30.8 of the QlikView Reference Manual (Version 8.5).

I tried the example in which the available field values depend on the login and it worked.

But I have some problems when I want to restrict several values in more than one field.

section application;
star is *;
load * inline
[DEPT,Company, Year
IS, 10001, 2006
IS,10002, 2007];


The table is linked via DEPT to the table in Section Access. When I Iog in with the user I can only see data where Company='10001' and Year='2006' or Company='10002' and Year='2007', but not for example Company='10002' and Year='2006'. One solution would be to write all possible combinations in a table, but that could get very time-consuming.

Any other suggestions how to handle this issue?

Tags (2)
3 Replies
prieper
Honored Contributor II

Security - Dynamic Data Reduction

Hi,

think you have to write all combinations. If there are more users having the same combinations, it may make sense group them and then to assign the rights to the groups.

HTH

Peter

mov
Esteemed Contributor III

Security - Dynamic Data Reduction

I think it's a question about the data model. Do you really need Company and Year in the same logical table? I think it should be like this:

section application;
star is *;
Table1:
load * inline
[DEPT,Company
IS, 10001
IS,10002];

Table2:
[Company, Year
10001, 2006
10002, 2007];

chematos
Valued Contributor II

Re: Security - Dynamic Data Reduction

I wolud try something like Michael says, but like this:

Table1:
load * inline
[DEPT,Company
IS, 10001
IS,10002];

Table2:

[DEPT,Year

IS, 2006

IS,2007];

hope this helps