Qlik Community

Ask a Question

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pixel Perfect NPrinting Help

Hello Qlik Community

I am trying to create a PDF report using Pixel Perfect and NPrinting that has a hours of operation field. The issue that I have is that my hours of operation come out on my NPrinting report as a continuous line:

Sun: Pharmacy ClosedMon: 09:00

AM - 05:00 PMTue: 09:00 AM -

05:00 PMWed: 09:00 AM - 05:00

PMThu: 09:00 AM - 05:00 PMFri:

09:00 AM - 05:00 PMSat: Pharmacy

Closed

Instead of:

Sun: Pharmacy Closed

Mon: 09:00AM - 05:00 PM

Tue: 09:00 AM - 05:00 PM

Wed: 09:00 AM - 05:00 PM

Thu: 09:00 AM - 05:00 PM

Fri:09:00 AM - 05:00 PM

Sat: Pharmacy Closed

I have tried creating a text object using the following code:

=if(TwentyFourFlag='X','Open 24 Hours',Sunday_Hours&chr(13)&Monday_Hours&chr(13)&Tuesday_Hours&chr(13)&Wednesday_Hours&chr(13)&Thursday_Hours&chr(13)&Friday_Hours&chr(13)&Saturday_Hours)

I have tried creating a field in the load script:

if(TwentyFourFlag='X','Open 24 Hours',Sunday_Hours&chr(13)&Monday_Hours&chr(13)&Tuesday_Hours&chr(13)&Wednesday_Hours&chr(13)&Thursday_Hours&chr(13)&Friday_Hours&chr(13)&Saturday_Hours) as Operation_Hours

I have tried creating a formula in the Nprinting using the same logic as above as well as replacing the chr(13) with chr(10). Nothing works. The PDF still outputs the hours of operations on one line.

Has anyone been able to create a carriage return or line feed to force a new line in NPrinting? Any help would be greatly appreciated.

Thanks,

Sherry

1 Solution

Accepted Solutions
rviel_dubo
Contributor III
Contributor III

Hi Sherry,

Go to property grid for your label, select "yes" for "Multiline" under the "Behavior" tab.

Properties.png

It did worked for me using Chr(10).

Addresses.png

Regards.

View solution in original post

3 Replies
rviel_dubo
Contributor III
Contributor III

Hi Sherry,

Go to property grid for your label, select "yes" for "Multiline" under the "Behavior" tab.

Properties.png

It did worked for me using Chr(10).

Addresses.png

Regards.

View solution in original post

Not applicable
Author

Works perfectly! Thank you for your assistance on this.

kdmarkee
Specialist
Specialist

Just what I was looking for, thanks.  It also works with chr(13).  I am using NPrinting April 2018.