Discussion Board for collaboration related to QlikView App Development.
I'm loading data from Active Directory. The user select looks more or less like this:
SQL SELECT distinguishedName, cn, displayName, mailFROM '$(vLDAP)';
Question: is it possible to load only the users who belong to a certain Group or several Groups before loading Groups themsleves?
@rwunderlich We also used your Script in Qlik Sense.
The same Error occurred: EQ_QVX_SIZELIMIT_EXCEEDED
Uncomment your FIRST 1000 line did not fix the error.I placed the "FIRST 1000" comment before the SQL SELECT (3 lines down). This worked.
BUT:After that, our Active Directory QVDs are incomplete. So its not a real Workaround.
Thanks for your response. Its commented. But even if not the result remain unchanged as this is preceding load. And >1000 rows retrieved from the AD directory before this step.
This support article seems to match your case: