topic Re: Section access in report level in QlikView

Section access in report level

santhosh_k_n — Tue, 18 Mar 2014 04:13:32 GMT

Hi All,

Is it possible to apply section access in chart level.

Let say, I am having sales and finance charts, now i want to apply section access on those charts like only finance reports are available for finance team and sales reports to sales team.

Re: Section access in report level

amit_saini — Tue, 18 Mar 2014 04:31:54 GMT

Hi Santhosh,

Yes it is very much possible, simply go to the chart properties-->>Under Layout Tab go to condition and give this condition below:

OSUser() = 'Give here user domain ID'

Thanks,

Re: Section access in report level

qlikpahadi07 — Tue, 18 Mar 2014 05:02:28 GMT

Yes, you can do that every chart are having chart ID which you can define in Excel itself for Section access.

Quite tough but yes we can achieve this.

Re: Section access in report level

santhosh_k_n — Tue, 18 Mar 2014 05:06:50 GMT

Thanks Amit,

But this will only work for single user login (Please correct me if am wrong)

Re: Section access in report level

amit_saini — Tue, 18 Mar 2014 05:17:38 GMT

Hi Santhosh,

This will work for 'N' number of users , give condition like this:

OSUser() = 'User1' or OSUser() = 'User2' or OSUser() = 'User3' and so on....

Thanks,

Re: Section access in report level

jagan — Tue, 18 Mar 2014 05:28:32 GMT

Hi,

Group the charts in separate sheets, for example Finance charts in one sheet and HR charts in one sheets. Please check the thread which explains you in implementing the sheet level access for users

Sheet level access

Regards,

Jagan.

Re: Section access in report level

santhosh_k_n — Tue, 18 Mar 2014 05:38:23 GMT

Hi Jagan,

Thanks for your suggestion but my requirement is in chart level section access

Re: Section access in report level

santhosh_k_n — Tue, 18 Mar 2014 05:39:18 GMT

Hi ,

Do you have any sample excel file for the same

Re: Section access in report level

amit_saini — Tue, 18 Mar 2014 05:52:29 GMT

Hi Santhosh,

Please see this video :

http://www.youtube.com/watch?v=2rF9v_TdbVk

Thanks,

Re: Re: Section access in report level

jagan — Tue, 18 Mar 2014 06:25:57 GMT

Hi,

Please find attached file for solution.

Script used is

Section Access;

LOAD * INLINE [

ACCESS, USERID

Admin, A

User, B

User, C

USer, D

];

Section Application;

SheetAccessMatrix:

LOAD * INLINE [

USERID, Dept

A,Sales

B,Sales

C,HR

D,HR];

If you login as A or B you will see Sales chart, if you login as C or D you will see HR chart. This is implemented by using

Chart Properties -> Layout -> Show Conditional

Hope this helps you.

Regards,

jagan.

Re: Section access in report level

santhosh_k_n — Mon, 24 Mar 2014 06:52:57 GMT

Hi Jagan,

Instead of dept, can i use a flag(0 or 1) and define the same layout option as u defined say like falg =1?