NPrinting – can you apply conditional formatting rules similar to what pixel perfect offers

[kdmarkee]

In pixel perfect reports, you can apply Formatting Rules on levels and individual fields to show/hide certain levels and data rows respectively.  It is a great filtering feature when you want to offer all the data in your QlikView app for users to work with from Access Point but want your NPrinting reports to only show a subset.  What is the equivalent of this using Formatting Rules for filtering if building an excel report instead of pixel perfect?  I have poke around in the excel template and tried to find help in the Community but haven’t figured it out.  Thanks.

[Ruggero_Piccoli]

Hi,

I suggest you to start by reading the official Qlik NPrinting help site. It is not necessary to use formatting rules to filter data. 

Qlik NPrinting supports section access as described in https://help.qlik.com/en-US/nprinting/February2020/Content/NPrinting/DeployingQVNprinting/Section-ac...

There are also filters https://help.qlik.com/en-US/nprinting/February2020/Content/NPrinting/ReportsDevelopment/Static-dynam... that can be associated to users to limit the dataset.

Best Regards,

Ruggero

[kdmarkee]

I think I need to provide more specifics as I don't think the simplistic Filters in NP will do the trick.  I'd like to be able to do these 2 things but maybe it is not possible in excel:

1) Let's say I have 3 reports where I want to put report 1 on the excel worksheet 1, report 2 on worksheet 2, and report 3 on worksheet 3 BUT each report (aka worksheet) needs its own specific filtering rules.

2) Let's say I have 1 report that I will put on worksheet 1 of an excel doc, but within that report I have 2 different fields that need to have their own unique filter.  I guess in a way, think of it like putting set analysis on a column but doing it in excel.

Thanks.

[Ruggero_Piccoli]

Hi,

Thanks for the new details.

1) I don't know your data model but if in all worksheets you want the same objects you could evaluate to use PAges.

1 and 2) I think you could evaluate object filters. You can create a normal filter and apply it to a single Excel template object, for example a table. 

In each report entity you can apply a single filter.

If you want to add the same entity with two or more different filter you need to add the same entity multiple times and apply a different filter to each one.

Best Regards,

Ruggero

[kdmarkee]

Thanks for the info and screen shots.  I tried putting a filter on my chart object but I am still getting all rows.  Not sure why, it seems pretty straight forward.  I set up a NP filter and then pulled into the Filter property item of the chart in my report template.  Frustrating...