Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Try this?
=If(QvUser()='UserName', 0)
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
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
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)
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.
Hello on document properties
i have check
initial Data reduction base on Section Access
Does i check Strict Exclusion
Thanks
Hi,
Do you have proper section access included too? i.e. data reduction?
See an explanation on strict exclusion from the following link