Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
pandreozzi
Creator
Creator

Hiding Sheets

I am very new to development and have a question/challenge. Here is my run down.

I am accessing a DB that has multiple tables and of those tables I am bringing in different types of data that needs to be displayed on different sheets in QlikView. On the "Main" page is where I select my client locations and from that selection I would like to show the additional sheets only if there is relevant data that needs to be displayed for the selected client. So in the sheet properties of the sheet I want to hide I see there is a show sheet condition. If there is no data I need to keep that sheet hidden. If there is data associated to the client I need to have the sheet appear with that data in a table.

I hope this is clear.

Thanks, Paul

16 Replies
Sergey_Shuklin
Specialist
Specialist

Hello, Paul!

You can manage sheets which will be shown to user using ActivateSheet action on some objects. After that you may hide them all (ctrl + alt + d -> hide tabrow).

pandreozzi
Creator
Creator
Author

HI Sergey. I am not sure how that will work if the hidden sheets are based on a relationship.

Example

On the main sheet I select a customer that may have data the needs to be displayed on sheet 2 but not sheet 3 and this is all based on the relationship of that customer I select to the other tables that carry that data. In this case I only need to see sheet 1 and 2 and not sheet 3. In other cases I may only need to see sheet 1 and 3 and not sheet 2 and finally I may need to see all 3 sheets. This is bases on the types of services sold to the customer. I also do not want to tie this to a button as I have read in other responses to other questions.

vishsaggi
Champion III
Champion III

Can you share a sample qvw file you are working on?

sacosta5
Contributor III
Contributor III

Hi Paul...

Yes if you go to sheet properties in general tab --> "Show Sheet" . Choose "Conditional" , use a variable to indicate whether or not to show it.


pandreozzi
Creator
Creator
Author

sure see attachment

pandreozzi
Creator
Creator
Author

I don't mean to seem lazy but how to I attach a qvw to this communication?

pandreozzi
Creator
Creator
Author

This is helpful but that is what I need help in doing. Creating such variable.

vishsaggi
Champion III
Champion III

So when you click on Reply button, on top left corner you can see Use Advanced editor link just click on it and you can see a link on bottom right corner "Attach", that is where you can attach sample files.

Capture.PNG

pandreozzi
Creator
Creator
Author

Thanks see attachment.