Discussion Board for collaboration on Qlik 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
Go to Solution.
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.
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.
I tried and it worked and combine with Jonathan's suggestion, it still works. thanks both
Good. it worked