How do I map one value to all values in a field?

[MK9885]

Hello,

I'd like to map a value in a field to all the values.

Ex: I've a value % coming from db and I've list of other values in my data model. I'd like to map % to all the other values in my data model.

Table1

%

From... DBview table

Table2

A

B

C

D

E

F

G

So If I select % from Table1 it should select all values in Table 2.

I've tried Applymap and other functions too but nothing seem to work. FYI, I need this for Section Access, Ironically % is not working as a wild card entry in DB for ADMIN roles. So I thought I'll do it in Qlik, where ADMIN is assigned a % and has access to all values.

Thanks.

stalwar1‌swuehl‌loveisfail‌@

[maxgro]

In section access you should use *, not %

* is for all listed values, not for all values

Introduction to Section Access

Section Access

[MK9885]

In qlik, yes we use * but in data base % is considered as wildcard.

So I've % coming from DB, hence my question is for %.

Thanks.

[MK9885]

Do you have any idea on how to implement SA through DB?

I've almost got it but I also want ADMIN to have full access to the data when in ACCESS POINT. He's only able to see limited fields, which is not the requirement.

I've unchecked the 'Strict Exclusion' but have check 'Initial Data reduction based on section access'

After unchecking the strict exclusion admin has full access and user can see only limited field.

Please suggest...

Thanks.

[maxgro]

Make a backup of your .qvw before adding section access

Best practice is to use strict exclusion

In Access Point the access type is always USER

If you want an user with full access, you can use star (*)

and add a dummy user to the section access with all the values (in your case 7 rows, A....G)

Look at page 18 of "Introduction to section access.pdf"

[jonathandienst]

What you are looking for is called a generic key. This is well described by hic here:

Generic keys