Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
denis115
Creator
Creator

conditional hide based on user

Hello !

Help me pease !

What condition I must put in sheet properties to achieve what I want?

I need to hide a sheet from only one user , another users must see this sheet, how can I do this?

Thanks !

I'm using ntname section  access.

I find a condition but it doesnt hepled me: if(osuser()='ntname',1,0)

25 Replies
denis115
Creator
Creator
Author

it also doesnt work

denis115
Creator
Creator
Author

Its to hard for me to understand what I have to do with all this, of course I understand that when you give 1 or 0 to a sheet but for what do we need this? :

Sheet_Security:

LOAD USERS as NM,

     SH01,

     SH02,

     SH03,

     SH04,

     SH05,

     SH06,

     SH07,

     SH08

FROM

'..\..\..\Dashboard\SectionAccess.xlsx'

(ooxml, embedded labels, table is SHEETS);

HirisH_V7
Master
Master

Hi,

You can use the below reduction line in your script & you can add the same in excel as new column.

so that you can handle it from there ,when new requirement for any user coming in.

LOAD ACCESS,

     NTNAME,

If(NTNAME='Your User',1,0) as [Reduction Line],

   

FROM

'..\..\..\Dashboard\SectionAccess.xlsx'

(ooxml, embedded labels, table is SA);

By this , you can use 'Reduction line = 1 ' as the sheet condition for showing the sheet.

Hope this helps,

Hirish.V

HirisH
“Aspire to Inspire before we Expire!”
denis115
Creator
Creator
Author

what is sarep and nm?

Anil_Babu_Samineni

May be this?

If(Match(OSUSER(), 'ntname'),1,0)

OR

If, this is from Authentication of Section Access, you could use this

if(Match(QVUSER(), 'ntname'),1,0)

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

Please check I have done a mod there.

You can use that reduction line in script and condition at sheet.

HirisH
“Aspire to Inspire before we Expire!”
avinashelite

I feel your OSuser has domain attached to it .....added a text box and use =OSUser() and see how the name is displayed and then is its domain\NTNAME then use

=SubField(OSUser(),'\',2)

denis115
Creator
Creator
Author

where do I need to write expression in text box?

avinashelite

in the front end ....and see how your getting the value and share the same with us

denis115
Creator
Creator
Author

i found