Qlik Community

Ask a Question

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH 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.