topic Mapping all id's to admin using section access in QlikView

Mapping all id's to admin using section access

rsdhavle — Tue, 09 Sep 2014 12:28:24 GMT

I have one table containing multiple ids

I have defined section access table in which i have entry as

NTName ID ACCESS

A * ADMIN

B 12 USER

C 114 USER

Now I am joining this section table with my main table containing multiple Ids on a field ID but when NTNAME A user logins who has admin privilages he is able to see only two ids defined in section access table that 12 and 114.. Why is that?

Am i missing on anything or join is incorrect?

Re: Mapping all id's to admin using section access

jonathandienst — Tue, 09 Sep 2014 12:41:43 GMT

* used like this means all the other defined values, as you have observed. You will need define the other values in some way. For example, create a dummy user with NONE for Access and one line for each of the IDs.

NTNAME, ID, ACCESS

Dummy, 1, NONE

Dummy, 2, NONE

...

Or else in your load script, translate the * line into one line per ID for the ADMIN user.

NTNAME, ID, ACCESS

A, 1, ADMIN

A, 2, ADMIN

...

HTH

Jonathan