topic Re: Qlik NPrinting Filters in Qlik NPrinting

Qlik NPrinting Filters

Shi — Wed, 16 Jun 2021 15:05:47 GMT

Hi to everyone!

I am struggling to understand how to use filters in Qlik NPrinting,

in particular Advanced Research and Evaluate Value.

For example if I want a range of period for a string field, let's say : YearMonth,

I tried to write these expressions using Advanced Research:

=Num#(left(YearMonth,4))<=2015

=Num#(left(YearMonth,4))<=2017 and Num#(left(YearMonth,4))>=2012

But them didn't work.

Could you someone help me, for that specific question and give me general advices to use Advanced Research and Evaluate Value.

I already read the official manual, and saw some videos tutorial.

Thanks a lot!

Re: Qlik NPrinting Filters

Frank_S — Wed, 16 Jun 2021 16:22:23 GMT

@Shi

I would begin by testing those expressions inside your Qlik sense app. Do they render the expected results?

Please also check these steps to ensure any syntax used is accurate.

Searching & Selecting Data (qlik.com) (You may need to log in to Qlik to access this informational training

https://help.qlik.com/en-US/sense/May2021/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/SetAnalysis/set-modifiers-advanced-searches.htm

Here is a video (in case you missed it) that describes the advanced search usage within NPrinting.

https://www.youtube.com/watch?v=8OxJpDSXkAk

Also consider this:

https://help.qlik.com/en-US/sense/May2021/Subsystems/Hub/Content/Sense_Hub/Scripting/functions-statements-not-recommended.htm

https://www.youtube.com/watch?v=8OxJpDSXkAk

Kind regards...

Re: Qlik NPrinting Filters

mjht — Wed, 16 Jun 2021 19:19:25 GMT

@Shi The video on advanced search that @Frank_S suggested is excellent. His suggestion to try the search in your qlik sense app is spot on also. Here is an example that I ran into myself. The Beginner's Tutorial app has filters on the Dashboard page for field Year, Quarter, Month etc. The field in the app is Date. So I thought in NPrinting I could create a filter looking for specific years. That app was using autocalendar and when I selected a year in the qlik sense app you could see in the field name in the selections at the top Date.autoCalendar.Year.

If I entered < 2013 in the search bar for the Year filter I did not see any results show up but when I entered

< 01/01/2013 then the year 2012 would appear.

So when I wanted to create a search filter expression in NPrinting - I first tried it out in the search bar on my qlik sense app.

In NPrinting, I wanted to get the year 2013 only so I entered this expression for the advanced search filter

>12/31/2012<1/1/2014 and it worked.

Another tip is to look in your data model to see how your field is defined - is it numeric, text etc

Hope this helps.