Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

Nprinting filter not working value with spaces?

I've done many nprinting reports where the value in the filter is a string with spaces but for some reason, this filter is not working correctly and I don't understand why. When I test it in the QVW, it shows values:

2020-10-23_15-51-10.jpg

But the Nprinting report has not worked and sometimes there is an error and sometimes not.

2020-10-23_15-44-20.jpg2020-10-23_15-49-17.jpg2020-10-23_15-51-41.jpg

Labels (2)
1 Solution

Accepted Solutions
Highlighted
Employee
Employee

Hi,

The first filter on the Governance_Phase field returns an empty dataset so the second is also empty. Are you sure you are connecting QlikView NPrinting 16 to the same .QVW as the first screenshot? Was that document correctly reloaded?

Try to run Qv.exe (QlikView Desktop) on the same computer where QlikView NPrinting 16 is running and with the same user and open the same QVW on the QlikView server. It must be opened correctly.

Best Regards,

Ruggero



Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.

View solution in original post

6 Replies
Highlighted

Is there section access and data reduction based on it?

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
Highlighted
Specialist
Specialist

No
Highlighted

just another thought..

Is it possible that this data comes from source which may have "blank" characters at the end of the values hence would require trimming when loading? Maybe value you are trying to filter looks like "Emergency Medicine" but in fact is "Emergency Medicine "...

 

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
Highlighted
Specialist
Specialist

I don't believe this is the case, but I will add a trim() to the script. When I pull the value from the list box, it looks like "Emergency Medicine".

Highlighted
Employee
Employee

Hi,

The first filter on the Governance_Phase field returns an empty dataset so the second is also empty. Are you sure you are connecting QlikView NPrinting 16 to the same .QVW as the first screenshot? Was that document correctly reloaded?

Try to run Qv.exe (QlikView Desktop) on the same computer where QlikView NPrinting 16 is running and with the same user and open the same QVW on the QlikView server. It must be opened correctly.

Best Regards,

Ruggero



Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.

View solution in original post

Highlighted
Specialist
Specialist

Yes, I am sure it's the same document and it's reloaded successfully.