Conditional Elimination of object in a excel Template

[imrasyed]

Hi Experts,

I have a Excel Report with two straight tables.

I want to dynamically remove a table based on the filter selected.

Ex: Excel Report Template.

Table1	Field1	Field2	Field3	Field4	Field5	Field6
	<Field1>	<Field2>	<Field3>	<Field4>	<Field5>	<Field6>
Table2	<Field7>	<Field8>	<Field9>	<Field10>	<Field11>	<Field12>

I have two publish task.

Task1: No filters 

Desired output :

Table1	Field1	Field2	Field3	Field4	Field5	Field6
	<Field1>	<Field2>	<Field3>	<Field4>	<Field5>	<Field6>
Table2	<Field7>	<Field8>	<Field9>	<Field10>	<Field11>	<Field12>

Task2: Product Filter

Desired Output:

Table1	Field1	Field2	Field3	Field4	Field5	Field6
	<Field1>	<Field2>	<Field3>	<Field4>	<Field5>	<Field6>

Basically I just wanted to get rid of Table 2 from the excel Template.

Is it possible to achieve this using a single report or do i need to create separate report ?

Your help is highly appreciated.

Thanks

Syed

[Frank_S]

Well I've tried conditionally hiding a chart based on a formula and or variable in the QlikView document and the table still appears in the report even if NP filter selections are made triggering the hidden chart condition.

I believe this is 'by design' as in many cases customer like the ability to use conditionally hidden charts in NP reports.

So the best solution might be to use a Pixel Perfect report and consider using 'formatting' rules to leverage the 'visible' yes/no option. Its not excel however but might help achieve your requirement in part at least.

https://help.qlik.com/en-US/nprinting/June2020/Content/NPrinting/PixelPerfectReports/Manage-Conditio...

Perhaps someone else here in this forum has a better option for you.

Kind regards...

[imrasyed]

Thanks a lot @Frank_S.

Will try  Pixel Perfect template meanwhile wait for any one in the forum has achieved(work around) it in Excel.