Qlik Community

QlikView Security & Governance

Discussion Board for collaboration on QlikView Security and Governance.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Section access using in clause of sql

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.

Labels (1)
1 Reply
Highlighted
Digital Support
Digital Support

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.