Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vStefano
Contributor II
Contributor II

Section Access - Data Reduction - Substring field

Good morning All,

I need to perform data reduction in a database in order to limit the access of the users just to their company.

Unfortunatly I do not have the company field in the database. However the company corresponds to the first two digits of the customer code. The field is named %CustomerKey

I have tried to set up something like below but it is not working. My idea was to limit, for example, the user Stefano just to see the company 30, hence all the customers beginning with 30.

Can someone help me?

section Access;

Load * Inline [
USERID, ACCESS, KEY
domain\Gino,ADMIN,
domain\Stefano,User,5
domain\Giovanni, User,2
ADMIN,INTERNAL\SA_SCHEDULER,*,
];

Section Application;

DataReduction:
Load * Inline [
KEY, %CustomerKey
2,'20*'
3,'21*'
4,'29*'
5,'30*'

];

 

 

Labels (1)
1 Reply
marcus_sommer
MVP & Luminary
MVP & Luminary

I think it's not possible - why not just creating this matching-field within the script with something like:

left(company, 2)

and using it within the data-reduction?

- Marcus