topic Section access using generic key in QlikView

topic Section access using generic key in QlikView https://community.qlik.com/t5/QlikView/Section-access-using-generic-key/m-p/1325677#M836559 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333px;">Hello All,</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">I implemented section access using generic key . I am getting as access denied when I opened as a user.But, its working fine for admin.Please provide your suggestion.</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Thanks,<BR />Rob</P><P style="font-size: 13.3333px;"><BR />Script:</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">TransactionTable_1:</P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;"> Load * inline</SPAN></P><P style="font-size: 13.3333px;">[</P><P style="font-size: 13.3333px;">COUNTRY,STATE,SALES,CITY</P><P style="font-size: 13.3333px;">NORTH,DELHI,5000,DELHI1</P><P style="font-size: 13.3333px;">SOUTH,HYD,5400,HYD1</P><P style="font-size: 13.3333px;">EAST,KOLKATA,8500,KOLKATA1</P><P style="font-size: 13.3333px;">NORTH,PUNJAB,3200,DELHI1</P><P style="font-size: 13.3333px;">SOUTH,TAMIL,8900,TAMIL1</P><P style="font-size: 13.3333px;">EAST,BENGAL,9000,UP1</P><P style="font-size: 13.3333px;">EAST,KOLKATA,1000,KOLKATA2</P><P style="font-size: 13.3333px;">];</P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;">Section Access;</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;">Load </SPAN></P><P style="font-size: 13.3333px;"> * inline [</P><P style="font-size: 13.3333px;"> ACCESS,  USERID, PASSWORD, COUNTRY,STATE,CITY</P><P style="font-size: 13.3333px;"> USER,  USER,  USER,NORTH,DELHI,<ANY></P><P style="font-size: 13.3333px;">ADMIN,  ADMIN,  ADMIN,<ANY>,KOLKATA,<ANY></P><P style="font-size: 13.3333px;">USER, USER1, USER1,EAST,<ANY>,<ANY></P><P style="font-size: 13.3333px;">];</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;">SECTION Application;</SPAN></P><P></P><P style="font-size: 13.3333px;">TempAuthorizationTable:</P><P style="font-size: 13.3333px;">  Load  COUNTRY &'|'& STATE &'|'& CITY as %AUTHID</P><P style="font-size: 13.3333px;">  Resident TransactionTable_1;</P><P></P><P style="font-size: 13.3333px;">  drop Table TransactionTable_1;</P><P style="font-size: 13.3333px;">TransactionTable:</P><P style="font-size: 13.3333px;">Load * ,</P><P style="font-size: 13.3333px;"> STATE &'|'& COUNTRY &'|'& CITY as AuthID ;</P><P style="font-size: 13.3333px;"> Load * inline</P><P style="font-size: 13.3333px;">[</P><P style="font-size: 13.3333px;">COUNTRY,STATE,SALES,CITY</P><P style="font-size: 13.3333px;">NORTH,DELHI,5000,DELHI1</P><P style="font-size: 13.3333px;">SOUTH,HYD,5400,HYD1</P><P style="font-size: 13.3333px;">EAST,KOLKATA,8500,KOLKATA1</P><P style="font-size: 13.3333px;">NORTH,PUNJAB,3200,DELHI1</P><P style="font-size: 13.3333px;">SOUTH,TAMIL,8900,TAMIL1</P><P style="font-size: 13.3333px;">EAST,BENGAL,9000,UP1</P><P style="font-size: 13.3333px;">EAST,KOLKATA,1000,KOLKATA2</P><P style="font-size: 13.3333px;">];</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;">AutorizationBridge:</SPAN></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Load</P><P style="font-size: 13.3333px;">   Upper(STATE &'|'& COUNTRY &'|'& CITY ) as %AUTHID, </P><P style="font-size: 13.3333px;">   STATE &'|'& COUNTRY &'|'& CITY as AuthID </P><P style="font-size: 13.3333px;">   Resident TransactionTable;</P><P style="font-size: 13.3333px;">   </P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Load</P><P style="font-size: 13.3333px;">   Upper('<ANY>' &'|'& COUNTRY &'|'& CITY) as %AUTHID, </P><P style="font-size: 13.3333px;">     STATE &'|'& COUNTRY &'|'& CITY as AuthID </P><P style="font-size: 13.3333px;">   Resident TransactionTable;</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Load</P><P style="font-size: 13.3333px;">   Upper(STATE &'|'& '<ANY>' &'|'& CITY) as %AUTHID, </P><P style="font-size: 13.3333px;">   STATE &'|'& COUNTRY &'|'& CITY as AuthID </P><P style="font-size: 13.3333px;">   Resident TransactionTable;</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Load</P><P style="font-size: 13.3333px;">   Upper(STATE &'|'& COUNTRY &'|'& '<ANY>') as %AUTHID, </P><P style="font-size: 13.3333px;">   STATE &'|'& COUNTRY &'|'& CITY as AuthID </P><P style="font-size: 13.3333px;">   Resident TransactionTable;</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Load</P><P style="font-size: 13.3333px;">   Upper(STATE &'|'& '<ANY>' &'|'& '<ANY>') as %AUTHID, </P><P style="font-size: 13.3333px;">   STATE &'|'& COUNTRY &'|'& CITY as AuthID </P><P style="font-size: 13.3333px;">   Resident TransactionTable;</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Load</P><P style="font-size: 13.3333px;">   Upper('<ANY>' &'|'& COUNTRY &'|'& '<ANY>') as %AUTHID, </P><P style="font-size: 13.3333px;">     STATE &'|'& COUNTRY &'|'& CITY as AuthID </P><P style="font-size: 13.3333px;">   Resident TransactionTable;</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Load</P><P style="font-size: 13.3333px;">   Upper('<ANY>' &'|'& '<ANY>' &'|'& CITY) as %AUTHID, </P><P style="font-size: 13.3333px;">   STATE &'|'& COUNTRY &'|'& CITY as AuthID </P><P style="font-size: 13.3333px;">   Resident TransactionTable;</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Load</P><P style="font-size: 13.3333px;">   Upper('<ANY>' &'|'& '<ANY>' &'|'& '<ANY>') as %AUTHID, </P><P style="font-size: 13.3333px;">    STATE &'|'& COUNTRY &'|'& CITY as AuthID </P><P style="font-size: 13.3333px;">   Resident TransactionTable;</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z Section access using generic key https://community.qlik.com/t5/QlikView/Section-access-using-generic-key/m-p/1325677#M836559 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333px;">Hello All,</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">I implemented section access using generic key . I am getting as access denied when I opened as a user.But, its working fine for admin.Please provide your suggestion.</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Thanks,<BR />Rob</P><P style="font-size: 13.3333px;"><BR />Script:</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">TransactionTable_1:</P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;"> Load * inline</SPAN></P><P style="font-size: 13.3333px;">[</P><P style="font-size: 13.3333px;">COUNTRY,STATE,SALES,CITY</P><P style="font-size: 13.3333px;">NORTH,DELHI,5000,DELHI1</P><P style="font-size: 13.3333px;">SOUTH,HYD,5400,HYD1</P><P style="font-size: 13.3333px;">EAST,KOLKATA,8500,KOLKATA1</P><P style="font-size: 13.3333px;">NORTH,PUNJAB,3200,DELHI1</P><P style="font-size: 13.3333px;">SOUTH,TAMIL,8900,TAMIL1</P><P style="font-size: 13.3333px;">EAST,BENGAL,9000,UP1</P><P style="font-size: 13.3333px;">EAST,KOLKATA,1000,KOLKATA2</P><P style="font-size: 13.3333px;">];</P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;">Section Access;</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;">Load </SPAN></P><P style="font-size: 13.3333px;"> * inline [</P><P style="font-size: 13.3333px;"> ACCESS,  USERID, PASSWORD, COUNTRY,STATE,CITY</P><P style="font-size: 13.3333px;"> USER,  USER,  USER,NORTH,DELHI,<ANY></P><P style="font-size: 13.3333px;">ADMIN,  ADMIN,  ADMIN,<ANY>,KOLKATA,<ANY></P><P style="font-size: 13.3333px;">USER, USER1, USER1,EAST,<ANY>,<ANY></P><P style="font-size: 13.3333px;">];</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;">SECTION Application;</SPAN></P><P></P><P style="font-size: 13.3333px;">TempAuthorizationTable:</P><P style="font-size: 13.3333px;">  Load  COUNTRY &'|'& STATE &'|'& CITY as %AUTHID</P><P style="font-size: 13.3333px;">  Resident TransactionTable_1;</P><P></P><P style="font-size: 13.3333px;">  drop Table TransactionTable_1;</P><P style="font-size: 13.3333px;">TransactionTable:</P><P style="font-size: 13.3333px;">Load * ,</P><P style="font-size: 13.3333px;"> STATE &'|'& COUNTRY &'|'& CITY as AuthID ;</P><P style="font-size: 13.3333px;"> Load * inline</P><P style="font-size: 13.3333px;">[</P><P style="font-size: 13.3333px;">COUNTRY,STATE,SALES,CITY</P><P style="font-size: 13.3333px;">NORTH,DELHI,5000,DELHI1</P><P style="font-size: 13.3333px;">SOUTH,HYD,5400,HYD1</P><P style="font-size: 13.3333px;">EAST,KOLKATA,8500,KOLKATA1</P><P style="font-size: 13.3333px;">NORTH,PUNJAB,3200,DELHI1</P><P style="font-size: 13.3333px;">SOUTH,TAMIL,8900,TAMIL1</P><P style="font-size: 13.3333px;">EAST,BENGAL,9000,UP1</P><P style="font-size: 13.3333px;">EAST,KOLKATA,1000,KOLKATA2</P><P style="font-size: 13.3333px;">];</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;">AutorizationBridge:</SPAN></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Load</P><P style="font-size: 13.3333px;">   Upper(STATE &'|'& COUNTRY &'|'& CITY ) as %AUTHID, </P><P style="font-size: 13.3333px;">   STATE &'|'& COUNTRY &'|'& CITY as AuthID </P><P style="font-size: 13.3333px;">   Resident TransactionTable;</P><P style="font-size: 13.3333px;">   </P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Load</P><P style="font-size: 13.3333px;">   Upper('<ANY>' &'|'& COUNTRY &'|'& CITY) as %AUTHID, </P><P style="font-size: 13.3333px;">     STATE &'|'& COUNTRY &'|'& CITY as AuthID </P><P style="font-size: 13.3333px;">   Resident TransactionTable;</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Load</P><P style="font-size: 13.3333px;">   Upper(STATE &'|'& '<ANY>' &'|'& CITY) as %AUTHID, </P><P style="font-size: 13.3333px;">   STATE &'|'& COUNTRY &'|'& CITY as AuthID </P><P style="font-size: 13.3333px;">   Resident TransactionTable;</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Load</P><P style="font-size: 13.3333px;">   Upper(STATE &'|'& COUNTRY &'|'& '<ANY>') as %AUTHID, </P><P style="font-size: 13.3333px;">   STATE &'|'& COUNTRY &'|'& CITY as AuthID </P><P style="font-size: 13.3333px;">   Resident TransactionTable;</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Load</P><P style="font-size: 13.3333px;">   Upper(STATE &'|'& '<ANY>' &'|'& '<ANY>') as %AUTHID, </P><P style="font-size: 13.3333px;">   STATE &'|'& COUNTRY &'|'& CITY as AuthID </P><P style="font-size: 13.3333px;">   Resident TransactionTable;</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Load</P><P style="font-size: 13.3333px;">   Upper('<ANY>' &'|'& COUNTRY &'|'& '<ANY>') as %AUTHID, </P><P style="font-size: 13.3333px;">     STATE &'|'& COUNTRY &'|'& CITY as AuthID </P><P style="font-size: 13.3333px;">   Resident TransactionTable;</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Load</P><P style="font-size: 13.3333px;">   Upper('<ANY>' &'|'& '<ANY>' &'|'& CITY) as %AUTHID, </P><P style="font-size: 13.3333px;">   STATE &'|'& COUNTRY &'|'& CITY as AuthID </P><P style="font-size: 13.3333px;">   Resident TransactionTable;</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Load</P><P style="font-size: 13.3333px;">   Upper('<ANY>' &'|'& '<ANY>' &'|'& '<ANY>') as %AUTHID, </P><P style="font-size: 13.3333px;">    STATE &'|'& COUNTRY &'|'& CITY as AuthID </P><P style="font-size: 13.3333px;">   Resident TransactionTable;</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Section-access-using-generic-key/m-p/1325677#M836559 2020-11-25T16:16:04Z Re: Section access using generic key https://community.qlik.com/t5/QlikView/Section-access-using-generic-key/m-p/1325678#M836560 <HTML><HEAD></HEAD><BODY><P>Best thing you can do when something is going wrong with the link field or its content: put the Sectiion Access; statement in comments, reload and check your data model and the linkage between SA table and the other tables.</P><P></P><P>More specifically, add a listbox for the USERID field to your document, select a value for which ACCESS=USER and see what happens with the remainder of the tables and fields.</P></BODY></HTML> Wed, 24 May 2017 07:44:38 GMT https://community.qlik.com/t5/QlikView/Section-access-using-generic-key/m-p/1325678#M836560 Peter_Cammaert 2017-05-24T07:44:38Z