topic Re: extended section access help in QlikView

extended section access help

gauthamchilled — Wed, 25 Nov 2020 16:16:04 GMT

I have a qlikview document with section access

Fact table is having data something like below columns

employee,

country,

department,

region,

tartgetstatus

period,

designation

section access table with auth key as combination of country_department_region as authkey

I can able to control the access successfully by giving appropriate country level,department level and region level access.

I am fine upto here...

problem is

Now i have another table called 'Controltable' with following columns.

country,

period,

showdata

so i want to show targetstatus first to some of the employee but not to some of the employee.

in the above fact table 'designation' column holds value 1 or 0. 1 being management, 0 beeing workingemployees. this is static.

using the 'showdata' column in the controltable, i want to control.

controltable:

country,period,showdata

usa,2015,0

usa,2014,1

uk,2014,1

canada,2014,1

showdata column here is going to be dynamic, i need to change it 1 or 0 based on the response from management.

since showdata for usa 2015 is 0, only the management will see 2015 data but not the rest of the employees.

how can i implement this in my existing section access.

Thanks

Gautham

Re: extended section access help

saikatghosh — Thu, 11 Aug 2016 06:16:06 GMT

Hi Gautham,

add department also in control table by that you can manage the department wise section access

regards

saikat

Re: extended section access help

Gysbert_Wassenaar — Thu, 11 Aug 2016 06:38:08 GMT

You need to merge the control table with the section access table. That will mean including the period and showdata fields in the authkey as well.

Re: extended section access help

gauthamchilled — Thu, 11 Aug 2016 06:45:45 GMT

Thanks gwassenaar‌

Oh! then the Auth table becomes bigger because of the multiple field combination?

Can i use autonumber for auth keys combination?

Can i drop it at the end since its not going to be used in the front end?

Gautham

Re: extended section access help

Gysbert_Wassenaar — Thu, 11 Aug 2016 06:49:32 GMT

Yes, the table will become larger.

Yes, you can use autonumber.

The section access table doesn't need to be dropped. It won't be part of the data model after the script is executed. You won't see a section access table in the Table Viewer.

Re: extended section access help

gauthamchilled — Thu, 11 Aug 2016 06:54:52 GMT

How about the Auth key? can i drop that fields if it consumes more memory?

Re: extended section access help

Gysbert_Wassenaar — Thu, 11 Aug 2016 07:01:43 GMT

No, that's used to restrict the access. If you drop it then everybody has access to all the data again.

Re: extended section access help

gauthamchilled — Thu, 11 Aug 2016 11:34:42 GMT

Say my section access table is like below:

User,country,department,region,period,Showdata

A,US,IT,North,2015,1

if i have 10 years of data, then i need to add 10 rows for each user per combination???

how can i tackle for upcoming years?

Is there any best way?

Re: extended section access help

Gysbert_Wassenaar — Thu, 11 Aug 2016 11:48:52 GMT

if i have 10 years of data, then i need to add 10 rows for each user per combination???

Yes.

how can i tackle for upcoming years?

Add them when you need them. Perhaps maintaining the section access table in an excel file works for you.

Re: extended section access help

gauthamchilled — Thu, 25 Aug 2016 03:59:49 GMT

instead of adding all periods for each user,

controltable:

country,period,showdata

usa,2015,0

usa,2014,1

uk,2014,1

canada,2014,1

section access excel

user,country, office,region

a,usa,hroffice,central

b,canada,xyzoffice,north

can i create section access table by adding all periods for each user without manually? by some means of joins?

can you help me to do that?

so that section access table inside dashboard script will be automically created like this below???

user,country,office,region,period

a,usa,hroffice,central,2015

a,usa,hroffice,central,2014

b,canada,xyzoffice,north,2014

Re: extended section access help

Gysbert_Wassenaar — Thu, 25 Aug 2016 06:45:42 GMT

can i create section access table by adding all periods for each user without manually? by some means of joins?

Yes, it doesn't matter how the table is created. It does not have to be an inline table or an excel file. If you can create the necessary records by joining several tables that will work too.

SA_Table:

LOAD

user,

country,

office,

region

FROM

...excel file ...

;

JOIN

SA_Table

LOAD

country,

period,

showdata

FROM

...control source table...

;

Re: extended section access help

gauthamchilled — Mon, 29 Aug 2016 04:21:30 GMT

Thanks a lot gwassenaar‌

Coming to end finally for the solution. I somehow maintained the control tables and section access. I combined the two fields into one.

now in the attached document in the SEEDATA column, if it is 1 then the user should not see that period that country data,

example in this attached document fy2015,france data will be available to PETER only (seedata is 0 against him)

'JOHN' and 'USER' should not see fy2015 france data as 'SEEDATA'column is 1 against them.

not sure what is wrong? please help

Re: extended section access help

gauthamchilled — Mon, 29 Aug 2016 07:08:01 GMT

Anyone have idea?

Re: extended section access help

Anonymous — Mon, 31 Oct 2016 14:33:11 GMT

Did you ever get a solution to this? I am having a similar issue.