Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
nihhalmca
Valued Contributor II

Show hidden sheets only

Hi All,

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

Thanks,

Nihhal.

1 Solution

Accepted Solutions
nihhalmca
Valued Contributor II

Re: Show hidden sheets only

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.

View solution in original post

10 Replies

Re: Show hidden sheets only

Hidden Sheets only means what? Can you eloberate more please

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
MVP & Luminary
MVP & Luminary

Re: Show hidden sheets only

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

HirisH_V7
Honored Contributor

Re: Show hidden sheets only

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

HirisH
“Aspire to Inspire before we Expire!”
ramasaisaksoft
Valued Contributor III

Re: Show hidden sheets only

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.

satheshreddy
Contributor III

Re: Show hidden sheets only

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 

nihhalmca
Valued Contributor II

Re: Show hidden sheets only

I want to show hidden sheets (not objects)

satheshreddy
Contributor III

Re: Show hidden sheets only

hi nihhal,

we can apply for sheets also  this process.

Regards

Sathish

Partner
Partner

Re: Show hidden sheets only

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

sravanthialuval
Contributor

Re: Show hidden sheets only

Hi,

Try this,

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

hide.PNG