https://community.qlik.com/t5/QlikView/Section-access-using-in-clause-of-sql/m-p/1681821#M1246257 <P>Not exactly sure what you are doing here, but best I can offer are some links that may be of some help, need further explanation of things in order to provide anything further.</P><P><A href="https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Security.htm" target="_blank">https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Security.htm</A></P><P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Section-Access/ba-p/1465766" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Section-Access/ba-p/1465766</A></P><P>The latter does have some additional data reduction posts in it, which may be what you are looking for here, not really sure.</P><P>Regards,<BR />Brett</P> Wed, 04 Mar 2020 20:32:30 GMT Brett_Bleess 2020-03-04T20:32:30Z https://community.qlik.com/t5/QlikView/Section-access-using-in-clause-of-sql/m-p/1672550#M1246253 <P>Hi All,</P><P>I have a table in a way AccessID,Query.</P><P>In the query section we have the rules defined as below :</P><P>ID in (5001,5002,5003,5004,5005,5006,5007,5008,5009,5010,5011,5012,<BR />5013,5014,5015,5016,5017,5018,5019,5020,5021,5022,5023,5024,5025,5026,5027,5028,5029,5030,5031,5032,5033,5034,5035)<BR />and<BR />Buy ID in (A5001,B5002,C5003,A5004,B5005,C5006,A5007,B5008,C5009,A5010,B5011,C5012,A5013,B5014,C5015,A5016,B5017,<BR />C5018,A5019,B5020,C5021,A5022,B5023,C5024,A5025,B5026,C5027,A5028,B5029,C5030,A5031,B5032,C5033,A5034,B5035<BR />)<BR />OR<BR />Buy ID in (A5001,B5002,C5003,A5004,B5005,C5006,A5007,B5008,C5009,A5010,B5011,C5012,A5013,B5014,C5015,A5016,<BR />B5017,C5018,A5019,B5020,C5021,A5022,B5023,C5024,A5025,B5026,C5027,A5028,B5029,C5030,A5031,B5032,C5033,A5034,<BR />B5035,A5035,B5036,A5036,B5037,A5037,A5035,B5036,A5036,B5037,A5037,B5038,A5038,A5036,B5037,A5037,B5038,A5038,<BR />B5039,A5039,A5037,B5038,A5038,B5039,A5039,B5040,A5040,A5038,B5039,A5039,B5040,A5040,B5041,A5041,A5039,B5040)</P><P>There are 75 ID across 500 Buy ID's for a single user so if i try to create a table as below&nbsp;</P><P>SOEID,ID,BuyID it will be a huge table for 3000 different AccessID's(Users) and and we might tend to over utilize&nbsp; the memory on reload.</P><P>Is there any way we can implement it in Qlikview without having a row wise combination of ID and Buy ID in a table across every userid.</P> Mon, 26 Jan 2026 18:19:17 GMT https://community.qlik.com/t5/QlikView/Section-access-using-in-clause-of-sql/m-p/1672550#M1246253 aniketsr 2026-01-26T18:19:17Z https://community.qlik.com/t5/QlikView/Section-access-using-in-clause-of-sql/m-p/1681821#M1246257 <P>Not exactly sure what you are doing here, but best I can offer are some links that may be of some help, need further explanation of things in order to provide anything further.</P><P><A href="https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Security.htm" target="_blank">https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Security.htm</A></P><P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Section-Access/ba-p/1465766" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Section-Access/ba-p/1465766</A></P><P>The latter does have some additional data reduction posts in it, which may be what you are looking for here, not really sure.</P><P>Regards,<BR />Brett</P> Wed, 04 Mar 2020 20:32:30 GMT https://community.qlik.com/t5/QlikView/Section-access-using-in-clause-of-sql/m-p/1681821#M1246257 Brett_Bleess 2020-03-04T20:32:30Z