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
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.
I tried and it worked and combine with Jonathan's suggestion, it still works. thanks both
Good. it worked
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.
Retrieving data ...