Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

joeybird
Contributor II

section access qlik sense

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

7 Replies
sorrakis01
Valued Contributor

Re: section access qlik sense

Hi,

Delete the last section

LOAD

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

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

RESIDENT Main;


Regards,

reddys310
Honored Contributor II

Re: section access qlik sense

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?

joeybird
Contributor II

Re: section access qlik sense

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

sorrakis01
Valued Contributor

Re: section access qlik sense

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/ManagingSecur...

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

joeybird
Contributor II

Re: section access qlik sense

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


sorrakis01
Valued Contributor

Re: section access qlik sense

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

joeybird
Contributor II

Re: section access qlik sense

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