-
Re: data reduction in section access using qliksense
Shahbaz Khan Mohammed Mar 27, 2017 1:35 PM (in response to shruthi PANNALA)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