Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Delete the last section
LOAD
[BOARD_SA] &'|'& [TYPE_SA] AS BOARD_TYPE_SA,
[BOARD_SA] &'|'& [TYPE_SA] AS BRIDGEID_SA
RESIDENT Main;
Regards,
Hi Joanna,
the load statement
creates an another tables, instead cant you make the table "My Bridge" have 3 columns and concatenate this data into the same table?
I need to this code to restrict access to Type. Plus Status, and Board
I need this code to work that's my issue
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:
[BOARD_SA] &'|'& [TYPE_SA] AS BOARD_TYPE_SA_2,
Regards
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
UPPER(Board) & '|' & UPPER("type") AS BOARD_TYPE_SA_2,
it works again, but circular reference returns
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:
UPPER(Board) & '|' & UPPER("type") AS BOARD_TYPE_SA
FROM [lib://C/listadoConsumos.xlsx]
(ooxml, embedded labels, header is 1 lines, table is Sheet0);
MyBridge:
[BOARD_SA] &'|'& [STATUS_SA] AS BOARD_STATUS_SA,
[BOARD_SA] &'|'& [STATUS_SA] AS BRIDGEID_SA
[BOARD_SA] &'|<ANY>' AS BRIDGEID_SA
'<ANY>|'& [STATUS_SA] AS BRIDGEID_SA
'<ANY>|<ANY>' AS BRIDGEID_SA
//******* This code works up to here
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
