Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
hopkinsc
Partner - Specialist III
Partner - Specialist III

NP Sept 18 filter query

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.

Filters1.JPGFilters2.JPGFilters3.JPG

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 @Stephen_Jasionowski

Thanks in advance

1 Reply