extended section access help

[gauthamchilled]

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

[Gysbert_Wassenaar]

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...

     ;

[gauthamchilled]

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

[gauthamchilled]

Anyone have idea?

[Anonymous]

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