Show hidden sheets only

[nihhalmca]

Hi All,

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

Thanks,

Nihhal.

[Anil_Babu_Samineni]

Hidden Sheets only means what? Can you eloberate more please

[marcus_sommer]

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]

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

[ramasaisaksoft]

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]

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]

I want to show hidden sheets (not objects)

[satheshreddy]

hi nihhal,

we can apply for sheets also  this process.

Regards

Sathish

[suraj_spins]

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]

Hi,

Try this,

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