Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

ronaldwang
Contributor

Chr(10) in Qlikview and Nprinting

 

I have used Chr(10) to change to a new line in Qlikview which is working fine, but when exporting this to excel template through Nprint then the change a new line is not reflected. Does anyone know why? thanks

 

1 Solution

Accepted Solutions
sureshqv
Esteemed Contributor III

Re: Chr(10) in Qlikview and Nprinting

Hi,

Am not sure, but when use any functions in qlik it will work,but if you use the Excel template as in Qlik Nprininting so it will take the excel functionality.

4 Replies
sureshqv
Esteemed Contributor III

Re: Chr(10) in Qlikview and Nprinting

Hi,

Am not sure, but when use any functions in qlik it will work,but if you use the Excel template as in Qlik Nprininting so it will take the excel functionality.

MVP
MVP

Re: Chr(10) in Qlikview and Nprinting

Just a guess, but did you try a CR/LF pair? That would be Chr(13) & Chr(10).

Qlikview is OK with just a LF, but Excel might expect the pair.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
ronaldwang
Contributor

Re: Chr(10) in Qlikview and Nprinting

I tried and it worked and combine with Jonathan's suggestion, it still works. thanks both

sureshqv
Esteemed Contributor III

Re: Chr(10) in Qlikview and Nprinting

Good. it worked

Community Browser