In this post I would like to share how to hide and show sheet in Qlikview.
1. Right click on empty space of the sheet and choose Properties...
2. When sheet properties dialog appear, go to General tab. In Show Sheet option, check on conditional radio button and type 1<>1 and then click OK. Please see picture below:
Now the sheet is disappeared.
3. When Sheet Properties dialog appear, go to General Tab and click on Always radio button in Show Sheet option. click OK buttion.
I. Hide sheet in Qlikview
To hide sheet, please follow a few steps below:1. Right click on empty space of the sheet and choose Properties...
2. When sheet properties dialog appear, go to General tab. In Show Sheet option, check on conditional radio button and type 1<>1 and then click OK. Please see picture below:
Set condition to hide sheet in sheet properties dialog |
II. Show hidden sheet in Qlikview
To show hidden sheet in qlikview, please follow a few steps below:- Go to menu bar, click on Settings and choose Document Properties...
- When Document Properties dialog appear, go to Sheets Tab --> click on the sheet which you wish to show and then click on Properties... button
How to hide and show sheet in Qlikview
Reviewed by BeiLover
on
9:56 PM
Rating:
No comments: