Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
heij1421
Partner - Contributor III
Partner - Contributor III

How to create a script with a combination of tables

Hi,

I have some master data tables:

Employees: User1 and User2
Divisions: 100, 200
Departments, ABCD, EFGH and IJKL
General ledgers: 7000, 8000, 8050, 8090, 9000, 9500 and 9999

Then I have a security table with 5 columns with some data:
User, division, department, generalledger_from, generalledger_to
User1, 100, ABCD, 8000, 8090
User1, 100, ABCD, 9500, 9999
User2, 200, <ANY>,7000, 9999
 

Out of these records I want to create a table to see which user is allowed to see which divisions, departments and general ledgers. Outcome should be a combination of all users, divisions, departments and general ledgers which the user is allowed to see based on the security table.

with <ANY> I mean that the user is allowed to see all departments

So I want to create a table like:

User, division, department, general_leger

User1, 100, ABCD, 8000
User1, 100, ABCD, 8050
User1, 100, ABCD, 8090

..

User2, 200, ABCD, 7000
User2, 200, EFGH, 7000
User2, 200, IJKL, 7000
User2, 200, ABCD, 8000
User2, 200, EFGH, 8000
.. etc

How do I create such a script?

 

2 Replies
heij1421
Partner - Contributor III
Partner - Contributor III
Author

Hi Marmentrout5,

Thanks for the reply.
I know section access. In fact the idea is that I want to use the result of the script in section access.