topic Re: NPrinting filter query in Qlik NPrinting

NPrinting filter query

hopkinsc — Tue, 08 Jan 2019 18:40:42 GMT

Hi all,

I am trying to mimic some selections made in QlikView using NPrinting 17 Sept 2018 version.

In QV i have actions on a text box which makes the following selections..

[Order Type] = SO, SD, CO, CD

[Last Code] = 500, 520, 540, 550

[Units] = CA

I can make these selections in QV without any problems even though [Last Code] = 500 is a grey value (it still appears in the current selections box though).

Now when i try and do the same in NP, because [Last Code] = 500 is grey, it clears all selections on that field, therefore my report has the wrong data within it.

Here are some screenshots of my filter in NP.

I have also attached the QVW used, the chart shows that i should have 182 rows extracted in the report, but the attached NP output has 19287 rows (because all [Last Codes] are included. .

Is anyone able to help please?

@Daniel_Jenkins @sjw

Thanks in advance

Re: NPrinting filter query

Daniel_Jenkins — Tue, 08 Jan 2019 21:04:38 GMT

Hi,

Change your filter definition for field Last Code to Numeric value is.

HTH - Daniel.

Re: NPrinting filter query

Lech_Miszkiewicz — Wed, 09 Jan 2019 07:25:52 GMT

Also as a side note - Dual values have to be also filtered using their numerical representation, although on front-end you would usually see text

regards

Lech

Re: NPrinting filter query

hopkinsc — Wed, 09 Jan 2019 08:59:18 GMT

Hi Daniel,

**bleep**, i knew it was something easy!

Thanks for your help!