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

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

MK9885 — Wed, 25 Nov 2020 16:16:04 GMT

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

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‌@

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

maxgro — Mon, 31 Oct 2016 13:25:22 GMT

In section access you should use *, not %

* is for all listed values, not for all values

Introduction to Section Access

Section Access

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

MK9885 — Mon, 31 Oct 2016 13:29:22 GMT

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.

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

MK9885 — Mon, 31 Oct 2016 13:35:11 GMT

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.

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

maxgro — Mon, 31 Oct 2016 13:55:07 GMT

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"

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

jonathandienst — Mon, 31 Oct 2016 14:02:55 GMT

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

Generic keys