NPrinting Filter

[Anonymous]

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.

[Stephen_Jasionowski]

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

[Anonymous]

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

[balabhaskarqlik]

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