Qlik Community

Ask a Question

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
imrasyed
Creator II
Creator II

Conditional Elimination of object in a excel Template

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.

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

 

I have two publish task.

Task1: No filters 

Desired output :

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

 

Task2: Product Filter

Desired Output:

Table1Field1Field2Field3Field4Field5Field6
 <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

 

 

 

Labels (2)
2 Replies
Frank_S
Support
Support

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

visible 'yes-no'.PNG

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

Kind regards...

We are just 'like' you and like to be liked when providing a helpful answer. You may also press the 'Solution Accepted' button if an answer provided resolves your question or issue... Cheers!
imrasyed
Creator II
Creator II
Author

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.