Skip to main content

QlikView Administration

Discussion Board for collaboration on QlikView Management.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
aniketsr
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
Brett_Bleess
Employee
Employee

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.