Hide Of 'Sheet Properties Option' for Qvw

[nihhalmca]

Hi All,

Please let me know the hide of "sheet properties" option in Qlikview, very needed

for instance, if we r/c on sheet it shows properties option that one should be hide

thanks in advance

Nihhal.

[matthieu_burel]

What is the question ? How to hide a sheet or the sheet properties ?

[rajeshvaswani77]

Settings --> Sheet properties and then give a condition that does not satisfy. Liek 1=0 or any othe rlogical condition you desire.

Thais will hide the sheet.

Thanks,

Rajesh Vaswani

[nihhalmca]

Hi Matthieu,

I need to give security to Qvw i.e End users are unable to see sheet properties option in Qvw

[rajeshvaswani77]

go to settings --> Sheet properties --> security tab --> last checik box option --> Access Sheet properties(users) uncheck this and say apply to all sheets.

This should resolve the issue for you.

Thanks,

Rajesh Vaswani

[nihhalmca]

Hi Rajesh, thanks for reply

but My requirment is "hide of sheer propertis option" only not sheet

Like if we righ click on sheet it shows properties opiton that one should be hide

[rajeshvaswani77]

Hi Nihaal,

I initially misunderstood your question. The below should help you in what you are looking for.

go to settings --> Sheet properties --> security tab --> last checik box option --> Access Sheet properties(users) uncheck this and say apply to all sheets.

This should resolve the issue for you.

Thanks,

Rajesh Vaswani

[nihhalmca]

Hi Rajesh, thanks for your valid answer

Incase of end user want to unhide sheet properties option, how can he resolve

Regards

Nihhal

[rajeshvaswani77]

No, the user cannot unhide once we do this.

thanks,

Rajesh Vaswani

[nihhalmca]

I think we only enable option and re deploy qvw to end users, am i correct