Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Lakshminarayanan_J

Section Access Creation

Dear All,

Need to create the section access based on Below template. 

The Region, subregion, country, ProductGroup available in Fact table,

ACCESS USERID LDAP_Name Type Region Subregion Country ProductGroup

 

 

@SwathiPulagam @vinieme12 @john_wang @rubenmarin @RafaelBarrios 

#

Lakshminarayanan J
To help users find verified answers, please don't forget to use the "Accept as Solution" button
Labels (1)
7 Replies
SunilChauhan
Champion II
Champion II

identify on which field you need to reduce Data.  if it is Region then Section access would below

section Access;

Load ACCESS,UserID,Upper(Region) as Region Inline [

ACCESS,UserID,Region

Admin,User1 ,*

User,User2 ,East

User,User3 ,West

User,User4 ,North

User,User5,South

];

Section Application;

Load from source Table

Load

LDAP_Name,Type,Upper(Region) as Region,Subregion,Country,ProductGroup

From Path

 

Sunil Chauhan
Lakshminarayanan_J
Author

@SunilChauhan 

Below are combination of data reduction, reduction will be based on any given column and it will have multiple value. 

For Example: Region Will have America,EURO for one user like wise for all the column.

ACCESS USERID LDAP_Name Type Region SubRegion Country ProductGroup OMIT Remarks
ADMIN LN LAK Unrestricted            
USER SA SAN Restricted Americas          
USER QA AQA Restricted   Latin America        
USER QA1 AQA Restricted Americas Latin America        
USER QA1 AQA Restricted     BE      
USER QA1 AQA Restricted Euro     OFR    
Lakshminarayanan J
To help users find verified answers, please don't forget to use the "Accept as Solution" button
SunilChauhan
Champion II
Champion II

you can write 

store above code in a Excel

section Access;

Load

ACCESS,USERID,LDAP_Name,Type,Region,SubRegion,Country,ProductGroup,OMIT,Remarks

From  ExcelPath

Section Application;

Load your Source Data and Link with Section access Table

Sunil Chauhan
Lakshminarayanan_J
Author

@SunilChauhan 

How can i link it with section access table , on basis of which field 

Lakshminarayanan J
To help users find verified answers, please don't forget to use the "Accept as Solution" button
SunilChauhan
Champion II
Champion II

if reduction Field is Region then Link with Region

 

if Reduction firld is more than one then Use Composite Key ( combination of field)

 

section Access;

Load ACCESS,USERID,LDAP_Name&Type&Region&SubRegion&Country&ProductGroup as KeyReduction

,OMIT,Remarks

Load

ACCESS,USERID,LDAP_Name,Type,Region,SubRegion,Country,ProductGroup,OMIT,Remarks

From  ExcelPath

Section Application;

Load your Source Data and Create same link key

LDAP_Name&Type&Region&SubRegion&Country&ProductGroup as KeyReduction  in source table

Sunil Chauhan
Lakshminarayanan_J
Author

@SunilChauhan 

It is working if have value in all the column , but when we have value in PRODUCT group and rest are empty , data are not displaying 

 

Lakshminarayanan J
To help users find verified answers, please don't forget to use the "Accept as Solution" button
SunilChauhan
Champion II
Champion II

replace  nonValue with Text BLANK

Sunil Chauhan