Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Section Access: no reduction for one type of users??

Hi All,

I have a few charts in a report, which have no relationship with users, and all other charts have relationship with users table. How can I implement a data reduction strategy so that the admin type users can see everything in the reports (including those few charts having no connection with users table), and the rest of users only see things that is allowed in data reduction.

I can provide more explanation if required. I will appreciate your help here

Regards

Arif

1 Solution

Accepted Solutions
pgalvezt
Specialist
Specialist

Hi, You have to create a Excel File (Within Domain users).

The Script that I have is:

Section Access;
Star is *;

LOAD
ACCESS,
NTNAME,
SERIAL,
USERID,
PASSWORD,
IDUSUARIO

FROM $(PathConfig)Accesos.xls (biff, embedded labels, table is [Accesos$])
WHERE Column_XLS = 1; //You have to create a Excel File where the column that user can see the reports = 1 the others user = 0 (And Then you have to reload and upload on your Production Server)

Section Application;

Star is *;

Hope Help You!

View solution in original post

6 Replies
pgalvezt
Specialist
Specialist

Hi, You have to create a Excel File (Within Domain users).

The Script that I have is:

Section Access;
Star is *;

LOAD
ACCESS,
NTNAME,
SERIAL,
USERID,
PASSWORD,
IDUSUARIO

FROM $(PathConfig)Accesos.xls (biff, embedded labels, table is [Accesos$])
WHERE Column_XLS = 1; //You have to create a Excel File where the column that user can see the reports = 1 the others user = 0 (And Then you have to reload and upload on your Production Server)

Section Application;

Star is *;

Hope Help You!

pgalvezt
Specialist
Specialist

Could you resolve this problem?

Not applicable
Author

Thanks pgalvezt,

The solution did help me.

Regards

Arif

pgalvezt
Specialist
Specialist

Now just You can create for each customer a column in excel and put 1 for the persons who need access.

Not applicable
Author

Actually, your solution did help me. However, the requirements got further complex, when I had to restrict the user to a data range within same column and it no longer remained a question of simple access yes no to a column. Therefore, in data reduction, I put the possible combination of data infront of each user. I dont know if there is any other solution to this problem. But for my earlier requirement, your solution worked

Regards

Arif

Not applicable
Author

I have another thread regarding tooltip editing. Can you please reply to that too

Regards

Arif