topic Re: section access qlik sense in App Development

section access qlik sense

joeybird — Tue, 29 Dec 2015 14:06:52 GMT

Hiya

this is in my main data table

Main:

type,

UPPER(type) AS TYPE_SA,

Board,

UPPER(Board) AS BOARD_SA,

"Status",

UPPER("Status") AS STATUS_SA,

UPPER(Board) & '|' & UPPER("Status") AS BOARD_STATUS_SA,

UPPER(Board) & '|' & UPPER("type") AS BOARD_TYPE_SA,

Section access

MyBridge:
LOAD
[BOARD_SA] &'|'& [STATUS_SA] AS BOARD_STATUS_SA,
[BOARD_SA] &'|'& [STATUS_SA] AS BRIDGEID_SA
RESIDENT Main;

LOAD
[BOARD_SA] &'|'& [STATUS_SA] AS BOARD_STATUS_SA,
[BOARD_SA] &'|<ANY>' AS BRIDGEID_SA
RESIDENT Main;

LOAD
[BOARD_SA] &'|'& [STATUS_SA] AS BOARD_STATUS_SA,
'<ANY>|'& [STATUS_SA] AS BRIDGEID_SA
RESIDENT Main;

LOAD
[BOARD_SA] &'|'& [STATUS_SA] AS BOARD_STATUS_SA,
'<ANY>|<ANY>' AS BRIDGEID_SA
RESIDENT Main;

******* This code works up to here

LOAD
[BOARD_SA] &'|'& [TYPE_SA] AS BOARD_TYPE_SA,
[BOARD_SA] &'|'& [TYPE_SA] AS BRIDGEID_SA
RESIDENT Main;

The section access works...however I have an issue here this keeps making a circular reference...how can this be prevented?

please help

Re: section access qlik sense

sorrakis01 — Tue, 29 Dec 2015 14:23:44 GMT

Hi,

Delete the last section

LOAD

[BOARD_SA] &'|'& [TYPE_SA] AS BOARD_TYPE_SA,

[BOARD_SA] &'|'& [TYPE_SA] AS BRIDGEID_SA

RESIDENT Main;

Regards,

Re: section access qlik sense

reddy-s — Tue, 29 Dec 2015 15:31:05 GMT

Hi Joanna,

the load statement

LOAD

[BOARD_SA] &'|'& [TYPE_SA] AS BOARD_TYPE_SA,

[BOARD_SA] &'|'& [TYPE_SA] AS BRIDGEID_SA

RESIDENT Main;

creates an another tables, instead cant you make the table "My Bridge" have 3 columns and concatenate this data into the same table?

Re: section access qlik sense

joeybird — Tue, 29 Dec 2015 15:38:50 GMT

Hiya

I need to this code to restrict access to Type. Plus Status, and Board

I need this code to work that's my issue

Re: section access qlik sense

sorrakis01 — Tue, 29 Dec 2015 15:51:11 GMT

Hi Joanna,

Sorry I don't understand what's your porpouse in Section Access but maybe this link can help you.

Look at dynamic

https://help.qlik.com/sense/1.1/en-US/online/Subsystems/Hub/Content/Scripting/Security/ManagingSecurityWithSectionAccess.htm

And if you like you can make a prove (to look for circular reference).

In your Original script change the last sequence for this one:

LOAD

[BOARD_SA] &'|'& [TYPE_SA] AS BOARD_TYPE_SA_2,

[BOARD_SA] &'|'& [TYPE_SA] AS BRIDGEID_SA

RESIDENT Main;

Regards

Re: section access qlik sense

joeybird — Wed, 30 Dec 2015 10:16:41 GMT

Hiya

I changed it as above, it runs, but it does not work, all filter panes on sheets are, greyed out.

so I updated the data below

Main:

type,

UPPER(type) AS TYPE_SA,

Board,

UPPER(Board) AS BOARD_SA,

"Status",

UPPER("Status") AS STATUS_SA,

UPPER(Board) & '|' & UPPER("Status") AS BOARD_STATUS_SA,

UPPER(Board) & '|' & UPPER("type") AS BOARD_TYPE_SA_2,

it works again, but circular reference returns

please help

Re: section access qlik sense

sorrakis01 — Wed, 30 Dec 2015 10:43:54 GMT

Hi Joanna,

Yo have 1 or more fields with the same Name in the 3 tables. Review it.

In the other comment I proposed this one for your understanding of circular reference:

Main:

LOAD

type,

UPPER(type) AS TYPE_SA,

Board,

UPPER(Board) AS BOARD_SA,

"Status",

UPPER("Status") AS STATUS_SA,

UPPER(Board) & '|' & UPPER("Status") AS BOARD_STATUS_SA,

UPPER(Board) & '|' & UPPER("type") AS BOARD_TYPE_SA

FROM [lib://C/listadoConsumos.xlsx]

(ooxml, embedded labels, header is 1 lines, table is Sheet0);

MyBridge:

LOAD

[BOARD_SA] &'|'& [STATUS_SA] AS BOARD_STATUS_SA,

[BOARD_SA] &'|'& [STATUS_SA] AS BRIDGEID_SA

RESIDENT Main;

LOAD

[BOARD_SA] &'|'& [STATUS_SA] AS BOARD_STATUS_SA,

[BOARD_SA] &'|<ANY>' AS BRIDGEID_SA

RESIDENT Main;

LOAD

[BOARD_SA] &'|'& [STATUS_SA] AS BOARD_STATUS_SA,

'<ANY>|'& [STATUS_SA] AS BRIDGEID_SA

RESIDENT Main;

LOAD

[BOARD_SA] &'|'& [STATUS_SA] AS BOARD_STATUS_SA,

'<ANY>|<ANY>' AS BRIDGEID_SA

RESIDENT Main;

//******* This code works up to here

LOAD

[BOARD_SA] &'|'& [TYPE_SA] AS BOARD_TYPE_SA_2,

[BOARD_SA] &'|'& [TYPE_SA] AS BRIDGEID_SA

RESIDENT Main;

Regards

Re: section access qlik sense

joeybird — Wed, 30 Dec 2015 13:27:54 GMT

Hiya

I have tried renaming tables and still have no joy, only when I get a circular reference it works.

here is my security table

Security:

LOAD * INLINE [

SA_LINK,BRIDGEID_SA

ALL,*

GROUP1,NORTH|<ANY>

GROUP2,<ANY>|ORDERACTIVE

GROUP3,SOUTH|ORDERACTIVE|CATERING

] ;

//North/south is board ....Orderactive is status ....and Catering is type

please help