topic Hiding Sheets in QlikView

Hiding Sheets

pandreozzi — Thu, 01 Jun 2017 16:50:26 GMT

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

Re: Hiding Sheets

Sergey_Shuklin — Thu, 01 Jun 2017 17:39:14 GMT

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).

Re: Hiding Sheets

pandreozzi — Thu, 01 Jun 2017 17:48:53 GMT

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.

Re: Hiding Sheets

vishsaggi — Thu, 01 Jun 2017 18:55:37 GMT

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

Re: Hiding Sheets

sacosta5 — Thu, 01 Jun 2017 19:02:07 GMT

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.

Re: Hiding Sheets

pandreozzi — Thu, 01 Jun 2017 19:34:42 GMT

sure see attachment

Re: Hiding Sheets

pandreozzi — Thu, 01 Jun 2017 19:37:18 GMT

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

Re: Hiding Sheets

pandreozzi — Thu, 01 Jun 2017 19:38:05 GMT

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

Re: Hiding Sheets

vishsaggi — Thu, 01 Jun 2017 20:37:52 GMT

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.

Re: Hiding Sheets

pandreozzi — Thu, 01 Jun 2017 20:45:41 GMT

Thanks see attachment.

Re: Hiding Sheets

vishsaggi — Fri, 02 Jun 2017 14:02:11 GMT

Check this if this is what you are looking for? And when there are no selections do you want the sheets to be shown or hidden? If hidden what sheets needs to be hidden? Check attached.

Expression used in sheet properties conditional check like below:

Check other sheet properties for the conditional expressions used based on table data.

Re: Hiding Sheets

pandreozzi — Mon, 05 Jun 2017 11:29:17 GMT

Thank You VIshwarath. I was out on Friday and will look at this today and get back to you.

Re: Hiding Sheets

pandreozzi — Wed, 07 Jun 2017 14:12:39 GMT

Vishwarath. I have tried this and unfortunately it did not work. Let me try to explain better only with two sheets and If I can get this to work than the other sheets will also work.

On what I call the "Main" sheet I have a text box that is populated with data. On the second sheet on what I call "Assets to Billing" sheet is billing information that is associated to the "Main" sheet depending on what the selection in the text object is. If there is no billing associated to the selection on the Main sheet than the Asset to Billing text object is blank so I would like to hide the sheet based on this condition.

Re: Hiding Sheets

pandreozzi — Wed, 07 Jun 2017 14:13:51 GMT

I also had someone suggest the Set Analysis but I am not sure how this will be used looking for null fields vs populated fields

Re: Hiding Sheets

RonaldDoes — Wed, 07 Jun 2017 14:49:19 GMT

Hi Paul,

I think this is what you'll need in the condition for your sheet.

=Count(DISTINCT ATBILLINGSITE)

Please find an example attached.

Hope this helps you.

With kind regards,

Ronald

Re: Hiding Sheets

vishsaggi — Wed, 07 Jun 2017 18:08:42 GMT

Can you elaborate and give an example selections you make and what has to happen?

Re: Hiding Sheets

pandreozzi — Wed, 07 Jun 2017 18:27:28 GMT

Hi Ronald that seemed to have worked. I also think someone else gave me a solution like this and I may not have implemented it correctly. Thanks for the quick response.