topic Re: section access two fields in QlikView

section access two fields

adiarnon — Sun, 15 Feb 2015 05:35:13 GMT

hi,

i have a problem-

im using section access but i need to use two fields-

some of my users need to see only some countries

and some of my users need to see only some companies.

there is no combination!

whats the best way to deal with this?

adi

Re: section access two fields

jafari_ervin — Sun, 15 Feb 2015 05:54:53 GMT

Hi,

Use your section access with two reduction key. like below

Section Access;

Load ACCESS,

NTNAME,

Countries,

Companies

from Excel.

Section Application;

Best,

Re: section access two fields

Oleg_Troyansky — Sun, 15 Feb 2015 06:36:25 GMT

The direction is correct, however the example will not work, unfortunately. Here is the list of steps:

1. Add 2 separate fields in Section Acces. Both fields and their values should appear in UPPER case.

2. Load the same fields SEPARATELY in two separate tables in Section Application and link them to the corresponding fields in your database (Country and Company). When the fields are linked separately, the security access is determined separately.

cheers,

Oleg Troyansky

www.masterssummit.com - take your QlikView skills to the next level!

Re: section access two fields

adiarnon — Sun, 15 Feb 2015 06:56:19 GMT

tnx oleg

in step 2-

now i have 2 field but they in one table

so i gues this is the resone why its not working...

can you explain me what should i do -

"Load the same fields SEPARATELY in two separate tables in Section Application "

how should i do that?

Re: section access two fields

Peter_Cammaert — Sun, 15 Feb 2015 20:23:49 GMT

In section application, after loading your data from different sources load some link tables like this:

SA_LINK_1:

LOAD UPPER(Country) AS COUNTRY, Country

RESIDENT WhateverTableContainsCountries;

SA_LINK_2:

LOAD UPPER(Company) AS COMPANY, Company

RESIDENT WhateverTableContainsCompanies;

Note that you may have to add additional logic if some users should be able to see all countries (*) or all companies, or everything from the two sets of dimension values.

Re: section access two fields

Oleg_Troyansky — Mon, 16 Feb 2015 01:45:52 GMT

Right on, exactly!

Re: section access two fields

Sahal — Tue, 11 Oct 2016 11:09:14 GMT

Hi,

This answer was simple and great UNTIL field values have null in them.

When i read about section access it uses AND and not OR in selections but how do i use OR with your simple(and great) answer?

This is my data:

Your two link tables will work for user1 because there are values in both Company and Country field.

But for user3 you will not get access to Company because country is null.

Why is this? and how can we it be fixed?

Re: section access two fields

Peter_Cammaert — Tue, 11 Oct 2016 15:55:15 GMT

Remember that even Section Access works with the standard QlikView associative logic; associations must be explicitly specified. NULL breaks all associations, so there won't be any links via the field that contains NULL, and your data model will probably be reduced to nothing.

The question you should ask yourself (knowing that NULL means 'nothing' and therefor QlikView works exactly as expected) is why is there a NULL value in an SA table? If this doesn't mean "nothing" but for example "any value is ok", then replace it by either an asterisk or a synthetic value like "ALL" and create the proper links in the Link tables between ALL and all link field values.