Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
alexantone
Creator
Creator

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
Partner - Specialist III
Partner - Specialist III

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. 

View solution in original post

alexantone
Creator
Creator
Author

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

View solution in original post

28 Replies
Anil_Babu_Samineni

Try this?

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

Capture.PNG

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
alexantone
Creator
Creator
Author

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
Partner - Specialist III
Partner - Specialist III

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
Creator
Creator
Author

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


agigliotti
Partner - Champion
Partner - Champion

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
Master II
Master II

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
Partner - Specialist III
Partner - Specialist III

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
Creator
Creator
Author

Hello on document properties

 

i have check

initial Data reduction base on Section Access

Does i check Strict Exclusion

 

Thanks

hopkinsc
Partner - Specialist III
Partner - Specialist III

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