How to show/hide sheets in Microsoft Excel reports conditionally?
FIRST CREATED ON 19 Dec 2024 I AUTHOR Emma Camacho
It
is possible to show/hide sheets in Microsoft Excel reports using the
Condition property of Elements together with the Exception Behavior.
Follow
the example to hide Sheets if the CY Sales = 0 and LY Sales = 0, that
is, show only Sheets that contain tables that make sense to show.
Add a condition to the Table element:
[Datasource].[Executive Dashboard - Partners Workshop].[Expression].[ [CY Sales]>0 or [LY Sales]>0 ]
And set the Exception behavior to Exclude Worksheet.
For more information, see Mail & Deploy Advanced - Conditions are Everywhere in Mail & Deploy.
Looking for Additional Guidance?
If you require more detailed information or further assistance, please visit our comprehensive Online Documentation. Our resources are designed to help you navigate all features and functionalities effectively.
Related Articles
Creating Custom Calculations in Excel Reports Using Mail & Deploy?
You want to create an Excel report using Mail & Deploy. Specifically, you have a table spanning columns A to K and need Column G to display the result of Column I × Column B, instead of using the result directly from the Qlik app. Solution: While the ...What is Report Culture Awareness, and how does it impact Mail & Deploy reports?
FIRST CREATED ON 30 Apr 2020 I AUTHOR Emma Camacho A culture is a set of rules that specify how numbers and dates are formatted (Windows Regional Settings). Generally speaking, the culture defines in what format numbers and dates are being presented ...How to synchronize cell insertion in an Excel report in Mail & Deploy (with example)?
FIRST CREATED ON 31 Jan 2024 I AUTHOR Emma Camacho Synchronizing cell insertion in an Excel report within Mail & Deploy ensures that your data is accurately aligned and formatted. Here's an example to guide you through the process: If you need a ...How to create an Excel report using Snowflake as a data source in Mail & Deploy (with example)?
FIRST CREATED ON 5 Mar 2024 I AUTHOR Emma Camacho Creating an Excel report using Snowflake as a data source in Mail & Deploy allows you to leverage powerful data analysis capabilities. Here's an example to help you get started: Use case: Display ...Handling Date Variables in Mail & Deploy Reports
You have a date variable in Qlik (formatted as DDMMYYYY), but when used in Mail & Deploy, it gets converted into a number. For example, the file output appears as File_45014.xlsx instead of File_29032023.xlsx. Solution: To resolve this issue, you can ...