Qlik Community

QlikView Security & Governance

Discussion Board for collaboration on QlikView Security and Governance.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Highlighted
alexantone
Contributor

SECTION APPLICATION

Hello

I have a SECTION ACCESS ==>it 's OK

I want to hide a tab  ==>So i had to add a colomn name on my section  ACCESS "VISIBLE"

my SECTION ACCESS

NTNAME id/ALEX  USER  , VISIBLE 1

NTNAME id/TOTO  USER  , VISIBLE 0

NTNAME id/SKY USER  , VISIBLE 1

my SECTION APPLICATION

what should I put?

 

 

Labels (1)
2 Solutions

Accepted Solutions
hopkinsc
Valued Contributor II

Re: SECTION APPLICATION

OK see the attached. It works for me. 

Change the excel to use your own NTNAME ans set VISUEL as you want. Also you need to tick 'Initial Data Reduction' in the doc properties then reload. 

Note that after the reload you will need to save and close QlikView down then open back up for section access to work. 

alexantone
Contributor

Re: SECTION APPLICATION

hello i don't want to check initial Data reduction because
there is an issue and all my users could have the message error (no authorization ...)

thank so lot for your help but i will make a varaible (if Ouser() ='ALEX' or Ouser()='TOTO' ...
28 Replies

Re: SECTION APPLICATION

Try this?

=If(QvUser()='UserName', 0)

Capture.PNG

Life is so rich, and we need to respect to the life !!!
alexantone
Contributor

Re: SECTION APPLICATION

hello

i dont want use this kind of script

i want to dispose on my section application like this

with the log of the active directory

id\ALEX 0

id\TOTO 1

if i log with TOTO => i must have one value =>1

if i log with ALEX => i must have one value =>0

but with the ntname , it don't unify the value

 

 

hopkinsc
Valued Contributor II

Re: SECTION APPLICATION

Hi, 

all you need to do is in the conditional show of the sheet, just type 

VISIBLE

That should then only show the sheet when the field VISIBLE is 1

alexantone
Contributor

Re: SECTION APPLICATION

yes but in my section APPLICATION
what is the script?
how i make the link with the section ACCESS


agigliotti
Honored Contributor II

Re: SECTION APPLICATION

you should have in section application a table like below:
table_name:
load
NTNAME
VISIBLE as Actual_Visible
resident your_section_access_table;

finally under sheet properties use the below expression:
if( Actual_Visible = 1, -1, 0 )
in conditional showing.
I hope it helps.
jyothish8807
Honored Contributor II

Re: SECTION APPLICATION

Hi Alex,

Yes, you can use the same approach. Set 0 or 1 under visible filed.

Then at sheet hide and show condition write.

if(match(OSUser,'ALEX ',Visible)

Best Regards,
KC
hopkinsc
Valued Contributor II

Re: SECTION APPLICATION

Hello, see attached QVW with an example. You just need to change the section access script to use your own NTNAME and reload to test. 

alexantone
Contributor

Re: SECTION APPLICATION

Hello on document properties

 

i have check

initial Data reduction base on Section Access

Does i check Strict Exclusion

 

Thanks

hopkinsc
Valued Contributor II

Re: SECTION APPLICATION

Hi, 

 

Do you have proper section access included too? i.e. data reduction?

See an explanation on strict exclusion from the following link

Section Access - Strict Exclusion