Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

data reduction in section access using qliksense

Hi Friends, I am implementing data reduction in section access using qliksense but it doesnt seems to working ,can some body guide me on implemeting data reuction in qliksense, below is screen shot of my code

I have user abc, and member name is one field name one of the tables in my data .

I would like to show the data related to particular member name called "Teacher" to that user abc, when i implement below code, it doesn't seems to be working, it is showing all the data to the user

DataReductionin SectionAccessError.jpg

1 Reply
Khan_Mohammed
Not applicable

Re: data reduction in section access using qliksense

Try the below script

Star is *;

section access;

LOAD * INLINE [

    ACCESS, USERID, JOBFUNCTION, ORG

    USER, CORP\USERNAME1, AAA, CA

    USER, CORP\USERNAME1, BBB, AB

    USER, CORP\USERNAME1, CCC, BC

    USER, CORP\USERNAME1, DDD, CD

    USER, CORP\USERNAME, *, *

    USER, INTERNAL\SA_SCHEDULER, ,

    USER, CORP\USERNAME2, EEE, AZ

    USER, CORP\USERNAME2, FFF, QA

    USER, CORP\USERNAME2, JJJ, RT

];

section application;

LOAD * INLINE [

    COUNTRY, SALES, MARGIN, PROFIT, ORG, JOBFUNCTION

    USA, 100000, 10000, 10, CA, AAA

    USA, 200000, 10000, 20, AB, BBB

    USA, 300000, 10000, 30, BC, CCC

    USA, 400000, 10000, 40, CD, DDD

    USA, 500000, 10000, 50, QW, EEE

    USA, 600000, 10000, 60, BB, FFF

    USA, 700000, 10000, 70, ZA, GGG

    USA, 800000, 10000, 80, AZ, HHH

    USA, 900000, 90000, 90, QA, III

    USA, 100000, 10000, 10, RT, JJJ

    EU, 110000, 11000, 110, ER, KKK

    EU, 120000, 12000, 120, WE, LLL

];

Note: replace Username with your users