SECTION APPLICATION

[alexantone]

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?

[alexantone]

yes i have a section ACCESS , and it s good since few months
i only want add this notion of visible on this application

[hopkinsc]

as long as the section access works then you can tick strict exclusion. Take a backup first though as if something goes wrong when strict exclusion is ticked you will be locked out of the application. 

[alexantone]

VISIBILITE:

LOAD
NTNAME,
VISUEL as LE_VISUEL
resident ACCESS where VISUEL >=0;

But when the ntname  ALEX is logging  , he can see VISUEL = 0 and VISUEL = 1 whereas  it is indicated  only ViSUEL = 1 on the resident SECTION ACCESS!

why it can't be indicated only VISUEL =1?

[hopkinsc]

Your WHERE clause states VISUEL>=0. it should just be >0

[alexantone]

i m agree with

it s just for my test all the user dont 'have the fields VISUEL with 0 or 1

so i just make an exemple with 2 users

ALEX =>VISUEL =0

TOTO=>VISUEL=1

log with ALEX cas see 0 and 1 for the VISUEL FIELD , same for TOTO

[hopkinsc]

What is your full script?

[alexantone]

SECTION ACCESS;
ACCESS:

LOAD 
    ACCESS,
    NTNAME,
    VISUEL 
   FROM
[..\..\..\..\HABILITATIONS\Habilitations.xlsx]
(ooxml, embedded labels, table is DAMIER);

SECTION APPLICATION;

VISIBILITE:

LOAD
NTNAME,
VISUEL as LE_VISUEL
resident ACCESS where VISUEL >=0;

[alexantone]

for your information VISUEL is not a field load in the model , it s only a way for me to have 0 or 1 to enabled or disabled to see a button ,That 's all

[agigliotti]

your script looks good.
in your sheet properties you should use something as below:
if( LE_VISUEL = 1, -1, 0 )
for conditional showing expression.

[hopkinsc · Accepted solution]

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.