topic Re: Show hidden sheets only in QlikView

Show hidden sheets only

nihhalmca — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Could you tell shortcut key to Show hidden sheets only (not objects) like "Ctrl+Shift+S".

Thanks,

Nihhal.

Re: Show hidden sheets only

Anil_Babu_Samineni — Mon, 02 Jan 2017 11:34:00 GMT

Hidden Sheets only means what? Can you eloberate more please

Re: Show hidden sheets only

marcus_sommer — Mon, 02 Jan 2017 11:36:11 GMT

I doubt that this would be possible. Instead of this it might be helpful to use a kind of an own-created Admin-mode within the visibilty-conditions like:

vAdminMode = true() or YourOtherRestrictions = true()

whereby you could switch the variable vAdminMode like you want or as an alternative you could you also use osuser() to see all sheets.

- Marcus

Re: Show hidden sheets only

HirisH_V7 — Mon, 02 Jan 2017 11:39:05 GMT

I hope its not there, as you mentioned Ctrl+Shift+S is the one (its for objects and sheets),

If you want something like that create a button action to activate all sheets.Pass only parmeter i.e showing all sheets and enable the action.

FYI,Hide Sheets and open them on button click | Qlik Community

-Hirish

Re: Show hidden sheets only

ramasaisaksoft — Mon, 02 Jan 2017 12:12:28 GMT

Hi Nihhal,

Are you asking Settings->Document Properties->Hide Tab Row (Check box)

i don't have idea for short cut.

some times developer will create N.no of sheets and he will display only 1 sheet with the help of Hide tab row check box.

by default this check box is unchecked if you want to see all sheets just uncheck that option.

Correct me if i miss understand your query.

Re: Show hidden sheets only

satheshreddy — Mon, 02 Jan 2017 12:33:42 GMT

Hi Nihhal,

you can achieve you requirement using Hide and Show Process only.

create variable and provide value 0.

let vshow = 0;

then go-to sheet properties show conditionally there use if condition and write like below.

vshow

and create button for hide and show process.

action--> external action ---> variable --> value place write same condition if(vshow=1,0,1).

Regards

Sathish

Re: Show hidden sheets only

nihhalmca — Mon, 02 Jan 2017 13:06:13 GMT

I want to show hidden sheets (not objects)

Re: Show hidden sheets only

satheshreddy — Mon, 02 Jan 2017 13:13:37 GMT

hi nihhal,

we can apply for sheets also this process.

Regards

Sathish

Re: Show hidden sheets only

suraj_spins — Wed, 01 Feb 2017 02:56:11 GMT

Nihhal,
I am not sure this is the right place to ask but I have seen you have resolved this issue.

Can you please help me understand, what was your resolution for these warnings?

Task shows Warning in QMC

Thank you

Suraj Gundapaneni

Re: Show hidden sheets only

sravanthialuval — Wed, 01 Feb 2017 10:16:06 GMT

Hi,

Try this,

Go to Settings-> Document Properties->Sheets-> Here you can find all hidden and normal sheets in application.

Re: Show hidden sheets only

nihhalmca — Fri, 17 Feb 2017 07:24:55 GMT

Hi All, thanks for your help.

It seems there is no short cut to see only sheets, Qlikview has only Ctrl+Shift+S shortcut to show hidden object and sheets.

So i am closing this post.