How to hide and show sheet in Qlikview

In this post I would like to share how to  hide and show sheet  in Qlikview.

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
Now the sheet is disappeared.

II. Show hidden sheet in Qlikview

    To show hidden sheet in qlikview, please follow a few steps below:

  1. Go to menu bar, click on Settings and choose Document Properties...
  2. When Document Properties dialog appear,  go to Sheets Tab --> click on the sheet     which you wish to show and then click on Properties... button


3. When Sheet Properties dialog appear, go to General Tab and click on Always radio button in Show Sheet option. click OK buttion.


Hope this post is helpful.
How to hide and show sheet in Qlikview How to hide and show sheet in Qlikview Reviewed by BeiLover on 9:56 PM Rating: 5

No comments:

Powered by Blogger.