Section access using in clause of sql

[aniketsr]

Hi All,

I have a table in a way AccessID,Query.

In the query section we have the rules defined as below :

ID in (5001,5002,5003,5004,5005,5006,5007,5008,5009,5010,5011,5012,
5013,5014,5015,5016,5017,5018,5019,5020,5021,5022,5023,5024,5025,5026,5027,5028,5029,5030,5031,5032,5033,5034,5035)
and
Buy ID in (A5001,B5002,C5003,A5004,B5005,C5006,A5007,B5008,C5009,A5010,B5011,C5012,A5013,B5014,C5015,A5016,B5017,
C5018,A5019,B5020,C5021,A5022,B5023,C5024,A5025,B5026,C5027,A5028,B5029,C5030,A5031,B5032,C5033,A5034,B5035
)
OR
Buy ID in (A5001,B5002,C5003,A5004,B5005,C5006,A5007,B5008,C5009,A5010,B5011,C5012,A5013,B5014,C5015,A5016,
B5017,C5018,A5019,B5020,C5021,A5022,B5023,C5024,A5025,B5026,C5027,A5028,B5029,C5030,A5031,B5032,C5033,A5034,
B5035,A5035,B5036,A5036,B5037,A5037,A5035,B5036,A5036,B5037,A5037,B5038,A5038,A5036,B5037,A5037,B5038,A5038,
B5039,A5039,A5037,B5038,A5038,B5039,A5039,B5040,A5040,A5038,B5039,A5039,B5040,A5040,B5041,A5041,A5039,B5040)

There are 75 ID across 500 Buy ID's for a single user so if i try to create a table as below 

SOEID,ID,BuyID it will be a huge table for 3000 different AccessID's(Users) and and we might tend to over utilize  the memory on reload.

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.

[Brett_Bleess]

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.

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Security.htm

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Section-Access/ba-p/1465766

The latter does have some additional data reduction posts in it, which may be what you are looking for here, not really sure.

Regards,
Brett