Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

paulyeo11
Valued Contributor II

How to force all my sheet which are hide activated ?

! ! ! ! !Hi All

I have create my app using a lot of hide sheet.

vSheetVisible=1

only when sheet is activate it then appear. my issue is a lot of hide sheet in my app are useless, i like to delete them.

But it is hide , i am unable able to locate them. so i cannot delete them.

Now i like to ask it there a command to force all sheet activated ?

Enclsoed my QVW , which have

vSheetVisible=1

vSheetVisible=2

vSheetVisible=3

how to make all of them not hide ?

Paul

1 Solution

Accepted Solutions

Re: How to force all my sheet which are hide activated ?

Press Ctrl + Shift + S to view all the sheets

Capture.PNG

9 Replies
Not applicable

Re: How to force all my sheet which are hide activated ?

Hi Paul,

In Settings> Document Properties> Security Tab

check "Show All Sheets and Objects" option then you will see all sheets in front end.

You can delete all unwanted sheets and Uncheck the option again in settings.

-Ashok

Re: How to force all my sheet which are hide activated ?

Press Ctrl + Shift + S to view all the sheets

Capture.PNG

Re: How to force all my sheet which are hide activated ?

Or view them under Document Properties

Capture.PNG

paulyeo11
Valued Contributor II

Re: How to force all my sheet which are hide activated ?

Hi Ashok

I have try to set , but it does not work . Where go wrong ?

Paul

Get Outlook for iOS<https://aka.ms/o0ukef>

paulyeo11
Valued Contributor II

Re: How to force all my sheet which are hide activated ?

Hi Ashok

I just check using my enclosed example , you approach work.

But in my actual QVW doc , it have more then 300 sheet . It does not work.

Remark :- My doc getting slow in loading, due to Yoo many sheet . I need to reduce those sheet which hide due to I have forget the number.

Paul

Get Outlook for iOS<https://aka.ms/o0ukef>

paulyeo11
Valued Contributor II

Re: How to force all my sheet which are hide activated ?

Hi Sunny

Control Shift S work fine now, my next issue is after that i am not able to open the sheet to view the chart and table . any work around ? As i need to view the page to see it the report it is impt ? if not i want to delete it. now i cannot view them.

cannot open.png

Re: How to force all my sheet which are hide activated ?

Delete your unwanted sheets directly from the document properties window

Capture.PNG

paulyeo11
Valued Contributor II

Re: How to force all my sheet which are hide activated ?

Hi Sunny

I manage to do a cleaning of a lot of old sheet , now it is okay and can load very fast. As those old sheet I only use once in every yr , so no point keep them. A lot of report now I do in QS , so the clean up will help a lot in speed up.

Paul

Get Outlook for iOS<https://aka.ms/o0ukef>

Re: How to force all my sheet which are hide activated ?

That's awesome

Community Browser