topic Re: NPrinting Filter in Qlik NPrinting

NPrinting Filter

Anonymous — Wed, 18 Jul 2018 15:06:22 GMT

Hi All,

Is it possible to add a filter to an NPrinting report as below:

Columns: Type, Origin, Dest

I would like to add the following filter: if the type = 'export' then uses Origin as 'MEL' otherwise use Dest as 'MEL'.

IF(Type='Export', Origin = 'Mel', Dest='Mel')

I have a report showing exports and imports for different countries. I need to create 2 separate NPrinting reports for Melbourne (MEL) and London (LHR)

Hope someone can help.

Re: NPrinting Filter

Stephen_Jasionowski — Wed, 18 Jul 2018 15:17:36 GMT

Currently this is only possible in NP16 using variable filters. This is a roadmap item for NPrinting 18.

Re: NPrinting Filter

Anonymous — Wed, 18 Jul 2018 15:33:13 GMT

Do you have any links on how this is done using variable filters?

Re: NPrinting Filter

BalaBhaskar_Qlik — Wed, 18 Jul 2018 16:53:22 GMT

May be try like this:

Create a variable in QS app (gave a default value)

Passed it to Edit template .

Create a filter and used "Evaluate" option instead of "Value is" and gave the value as vRegion(Variable in my case)

evaluate =vRegion

Ran the report to get the variable output as the default value

This way variable is passed from QS app to Report via NPrinting Variable .

Check this link:

https://help.qlik.com/en-US/nprinting/April2018/Content/ReportsDevelopment/Static-dynamic-filters.htm