topic Re: All but one values on a NPrinting filter in Qlik NPrinting

All but one values on a NPrinting filter

Gestion-PSD — Wed, 25 Sep 2019 18:40:54 GMT

Hi all,

We're looking for the best way to filter all but one values of a field in a NPrinting report. We're sure than the way is to create a filter over the field, but we aren't sure about how this filter would be.

A simple approach is to create the filter and add all values except the one we don't want to show in the report. But it isn't a good approach because if in the future we add other values to this field, they won't appear in the report because they won't be on the value lists of the filter.

We think the best way is to filter values by "Evaluate value" option and insert a expresion like "Field -= value_not_to_show", but we'd read in Qlik Help than the result of the evaluation mut be an unique value, so it doesn't seem a solution.

ignore this field value in the QlikSense app data load is not a solution.

Could you help us?

Thanks in advance.

Re: All but one values on a NPrinting filter

Gestion-PSD — Fri, 05 Jul 2019 07:50:32 GMT

Hi all again,

One solution is to create a new flag field in QS app with the neccesary logic (=1 if value must be showed, =0 is not) and create the NPrinting filter about that field, as we've recently read in the Community.

But we're searching for a solution in NPrinting, if it's possible, in order to not to modify QS app.

Thanks!

Re: All but one values on a NPrinting filter

Daniel_Jenkins — Mon, 08 Jul 2019 03:01:30 GMT

Hi @Gestion-PSD ,

You are in luck 🙂 The latest version of NPrinting (July 2019) introduces Advanced Search type filters that you can use to do this very easily.

Here are some examples: https://community.qlik.com/t5/Qlik-NPrinting-Documents/Examples-of-Advanced-Search-Filters/ta-p/1594779

In the above project, lets say you want a filter that excludes all transactions for year 2018 (all but 2018). You can use a filter like this:

Date field Advanced search filter with definition =Year(Date) <> 2018

HTH - Daniel.

Re: All but one values on a NPrinting filter

Gestion-PSD — Tue, 09 Jul 2019 07:17:17 GMT

Hi Daniel,

Thanks!

The NPrinting version we've installed rigth now (November '18) hasn't this feature available.

We're thinking of upgrade our QS & NP servers. This is another good reason to do that.

Thanks, again.

Re: All but one values on a NPrinting filter

Stephen_Jasionowski — Wed, 10 Jul 2019 08:15:14 GMT

In addition to Daniel's solution, select excluded value filters are on the roadmap for the September 2019 release

Re: All but one values on a NPrinting filter

tomdon14 — Wed, 28 Aug 2019 19:32:27 GMT

Hello - the advanced search capability is a great addition.

I have a requirement to display the excluded value in the report. I have tried achieve this by creating various formulas but have not been able to find a way to display the excluded value.

Any help is greatly appreciated.

Thanks…Tom

Re: All but one values on a NPrinting filter

Stephen_Jasionowski — Wed, 28 Aug 2019 19:47:10 GMT

Tom - select excluded filters are part of the September 2019 release so stay tuned...

Re: All but one values on a NPrinting filter

tomdon14 — Thu, 29 Aug 2019 17:44:15 GMT

Thank you Stephen!

Re: All but one values on a NPrinting filter

Lech_Miszkiewicz — Fri, 30 Aug 2019 02:53:32 GMT

SEP2019 TP is now out and available - looks great to me. cheers!

Re: All but one values on a NPrinting filter

Ruggero_Piccoli — Fri, 30 Aug 2019 06:40:35 GMT

September 2019 Technical Preview is available at the link https://community.qlik.com/t5/Qlik-NPrinting-September-2019/bd-p/Qlik_NPrinting_Sep_2019_TP