Sheet Security

[smilingjohn]

Hi

My requirement was to show the sheets according to user login and i was suggested in the

Qlikview community to follow the steps and i did , but unfortunately i am not able to achieve it

All the sheets are visible  for all the users , Can someone help me out please

[Chanty4u]

hi

goto  document properties>security tab> check the show all sheets and objects option

hope this helps you

Thank you

suresh

[Anonymous]

ou use Show sheet conditional (e.g. SHEET1=1)?

[avinashelite]

Hi

Did you check the Initial data reduction in the document properties ?

after this go to each sheet Properties and and according to the code , in the sheet properties you have the option like always and condition > in condition. If the sheet id is 1 than use =SHEET1

[Siva_Sankar]

John,

Find the document with screenshots to implement sheet level section access.

[antoniotiman]

Hi John,

See Attachement

ADMIN psw ADMIN@1 -> SHEET1/2

KANE psw WWE1 -> SHEET3

[smilingjohn]

HI Avinash please find my qlikview file, login as ADMIN and pswd ADMIN@1

and edit script paswd is    @dmin

My requirement is if i login with  Kane i should see only Branch and Level

if i login with ADMIN i have to see only Brand

Regards

JOhn

[smilingjohn]

Thanku So Much Antanio its working , i expect one more help from you

I have used the below code in section Access , which works perfectly for me , the below code will make the dashboard to display only those brands for defined user , now i want to apply the sheet level security for the same code is it possible ?

[antoniotiman · Accepted solution]

Hi John,

I'm sorry I'm late.

See attachement

I add use John psw WWE2

Regards,

Antonio

[smilingjohn]

Thank you So much Antonio  , ur help really appreciated