topic Re: star symbol in section access in QlikView

star symbol in section access

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

hi,

I understand * means all in section access.

i wanted to control access using three field office, region and department.

Star is *;

Section Access;

Section_Access:

LOAD UPPER(NTNAME) as NTNAME,

//UPPER(NTNAME) as USER,

ACCESS,

ROLEACCESS,

UPPER(COUNTRY) AS COUNTRY,

UPPER(REGION_SA) AS REGION ,

UPPER(DEPARTMENT) AS DEPT,

UPPER(OFFICE) AS [OFFICE]

From SA.xls file;

say for example, i give access to one user particular country, and region and i want all the departments in the region to be visible to that person. * not working.

how can i handle this to get possible values of the department in section access.

earlier i used auth key combinations from the example described by HIC. but my application is big and more than 6 fields are in my actual application the key comination creation is taking long time to load.

so i decided to use straight forward approach and star is not woking..

can anyone help to sort out this issue?

Gautham

Re: star symbol in section access

arvind_patil — Wed, 02 Aug 2017 03:46:37 GMT

Hi Gautham,

* Is consider all those field values which you mentioned in section access file in your case in SA.xls.

If you mentioned in that field all values then only show.

Thanks,

Arvind Patil

Re: star symbol in section access

balar025 — Wed, 02 Aug 2017 04:32:37 GMT

Hi Gautham,

I think you have to go with bridge table concept.

For example

Section Access;

Security:

Load * Inline

[

ACCESS,NTNAME,NTCOUNTRY

ADMIN,U1,*

USER,U2,IN

USER,U3,UK

USER,U4,US

]

Section Application;

Country_Bridge:

Load

Country, // tio link with current data model.

Country as NTCOUNTRY

from geo table;

This might help you to over come your issue.

Re: star symbol in section access

neha_shirsath — Wed, 02 Aug 2017 05:05:51 GMT

Refer attached document. Go through it. On page no 16-17 the concept of '*' is given.

Re: star symbol in section access

gauthamchilled — Wed, 02 Aug 2017 11:42:48 GMT

Any help on how to get the possible values under department for the region and office?

Re: star symbol in section access

neha_shirsath — Wed, 02 Aug 2017 11:56:44 GMT

Can you post sample data.