topic Re: Alignment issue with N Printing file in QlikView

Alignment issue with N Printing file

venkatbza — Wed, 25 Nov 2020 16:16:04 GMT

Hello All

i have created one Nprinting file and when i am running that nprinting file the output generated in the excel is not showing the correct alignment. Even though the object which i have created in qlikview and using as it is in NPrinting . The alignment is showing perfect at the qlikview object level but when i am using that object in the NPrinting and executing it in excel , the output generated in excel is not showing exact alignment

Request you to please suggest what can be done in this scenario or is there any solution for this

Regrads

Venkat

Re: Alignment issue with N Printing file

neha_sri — Wed, 03 Jan 2018 12:17:35 GMT

Hi Venkat,

Nprinting takes Excel by default formatting i.e number on left and text on right. In order to keep the same formatting as qlikview, bring the expression as number from qlikview using presentation functionality of Qlikview

Regards,

Neha

Re: Alignment issue with N Printing file

Chanty4u — Wed, 03 Jan 2018 12:50:58 GMT

yes,

but you need to do the formatting in excel if you need and in designer select the table and right clik properties

below you un check the option keep source format and run.

Note: Nprinting only fetch the data from Qlik and if you want to do any formatting its depends on template which you are making. [it will take native formatting[

Re: Alignment issue with N Printing file

eleni_theodorid — Wed, 31 Oct 2018 15:38:07 GMT

Hi,

I am facing the same issue using a pivot table in excel template I need to align Dimensions normally but the expressions centered. Have you found any solution?

NP version: June 2018

QV version: November 2017 sr5

Regards,

Eleni

Re: Alignment issue with N Printing file

Akhilesh — Thu, 25 Apr 2019 07:19:32 GMT

Dear Neha,

There's no option in Qlikview presentation functionality to use the expression as no.

Please suggest where I get it