NPrinting filter query

[hopkinsc]

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

[hopkinsc]

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

[Daniel_Jenkins · Accepted solution]

Hi,

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

HTH - Daniel.

[Lech_Miszkiewicz]

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 

[hopkinsc]

Hi Daniel,

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

Thanks for your help!