Section Access limitation of 1 million (1M) rowsArticle Number: 000048245 | Last Modified: 2019/02/12
//Admin,Service users USERS: LOAD * INLINE [ KEY,USERNAME,ACCESS *,DOMAIN\QVSERVICE,ADMIN *,DOMAIN\ADMINISTRATOR,ADMIN *,INTERNAL\SA_SCHEDULER,ADMIN *,INTERNAL\SA_ENGINE,ADMIN]; //User DOMAIN\AE92242 concatenate LOAD '1-' & RecNo() as KEY, 'DOMAIN\AE92242' as USERNAME, 'USER' as ACCESS AUTOGENERATE 1000200; //User DOMAIN\AE92241 CONCATENATE LOAD '2-' & RecNo() as KEY, 'DOMAIN\AE92241' as USERNAME, 'USER' as ACCESS AUTOGENERATE 1000400; Section Access; load ACCESS, USERNAME as USERID, KEY Resident USERS;
Upon opening the app, both users will only see 1,000,000 values and will be missing the remaining 200 and 400 values respectively.
Qlik Sense any version
Primary Design Blog link:
Section Access/Data Reduction links:
Have a Question?
Search Qlik's Support Knowledge database or request assisted support for highly complex issues.Submit a case
Experiencing a serious issue, please contact us by phone. View phone numbers and hours by region.