Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
joeybird
Creator III
Creator III

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
Specialist
Specialist

Hi,

Delete the last section

LOAD

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

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

RESIDENT Main;


Regards,

reddy-s
Master II
Master II

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
Creator III
Creator III
Author

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
Specialist
Specialist

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
Creator III
Creator III
Author

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
Specialist
Specialist

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
Creator III
Creator III
Author

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