topic Re: SECTION APPLICATION in QlikView

SECTION APPLICATION

alexantone — Mon, 26 Jan 2026 18:19:17 GMT

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?

Re: SECTION APPLICATION

Anil_Babu_Samineni — Mon, 10 Dec 2018 10:21:11 GMT

Try this?

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

Re: SECTION APPLICATION

alexantone — Mon, 10 Dec 2018 10:26:05 GMT

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

Re: SECTION APPLICATION

hopkinsc — Mon, 10 Dec 2018 10:27:00 GMT

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

Re: SECTION APPLICATION

alexantone — Mon, 10 Dec 2018 10:31:55 GMT

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

Re: SECTION APPLICATION

agigliotti — Mon, 10 Dec 2018 10:32:24 GMT

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.

Re: SECTION APPLICATION

jyothish8807 — Mon, 10 Dec 2018 10:41:25 GMT

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)

Re: SECTION APPLICATION

hopkinsc — Mon, 10 Dec 2018 10:44:32 GMT

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.

Re: SECTION APPLICATION

alexantone — Mon, 10 Dec 2018 11:11:20 GMT

Hello on document properties

i have check

initial Data reduction base on Section Access

Does i check Strict Exclusion

Thanks

Re: SECTION APPLICATION

hopkinsc — Mon, 10 Dec 2018 11:19:25 GMT

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

Re: SECTION APPLICATION

alexantone — Mon, 10 Dec 2018 11:24:55 GMT

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

Re: SECTION APPLICATION

hopkinsc — Mon, 10 Dec 2018 11:27:59 GMT

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.

Re: SECTION APPLICATION

alexantone — Mon, 10 Dec 2018 11:37:19 GMT

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?

Re: SECTION APPLICATION

hopkinsc — Mon, 10 Dec 2018 11:40:40 GMT

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

Re: SECTION APPLICATION

alexantone — Mon, 10 Dec 2018 11:44:20 GMT

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

Re: SECTION APPLICATION

hopkinsc — Mon, 10 Dec 2018 11:45:18 GMT

What is your full script?

Re: SECTION APPLICATION

alexantone — Mon, 10 Dec 2018 11:48:59 GMT

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;

Re: SECTION APPLICATION

alexantone — Mon, 10 Dec 2018 11:53:21 GMT

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

Re: SECTION APPLICATION

agigliotti — Mon, 10 Dec 2018 11:56:23 GMT

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

Re: SECTION APPLICATION

hopkinsc — Mon, 10 Dec 2018 12:15:15 GMT

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.