topic Re: Hiding sheets and showing sheets depending on data availability in QlikView

Hiding sheets and showing sheets depending on data availability

Mon, 31 Aug 2015 02:57:46 GMT

Hello

I have a question when hiding and showing sheets depending on data availability.

I managed to hide sheets with null data by setting condition under sheet property. (General-> Show Sheet -> Conditional -> Set Conditions)

It seems once the sheets are hidden, they are going to be hidden for good even thou the data is reloaded and I expect to see the sheets that I set to hide previously.

Is there any ways that I can reactivate the sheets?

Any advice would be appreciated.

Thanks much,

Hitomi

Re: Hiding sheets and showing sheets depending on data availability

jagan — Mon, 31 Aug 2015 03:36:34 GMT

Hi,

You can hide the sheets by using the conditions like this

=Sum(Sales) > 0

=Count(Orders) > 0

If this type of conditions fails it hides the sheets and if this condition pass then it will show the sheets.

Regards,

Jagan.

Re: Hiding sheets and showing sheets depending on data availability

Mon, 31 Aug 2015 03:54:01 GMT

Thank you so much Jagan! It worked!!!!!

Re: Hiding sheets and showing sheets depending on data availability

jagan — Mon, 31 Aug 2015 04:06:37 GMT

Hi,

If you got the answer please close this thread by giving Correct Answer to the post which helps you in the getting the answer.

Regards,

Jagan.