topic Re: Excel formating in Nprinting in Qlik NPrinting

Excel formating in Nprinting

Anonymous — Fri, 28 Oct 2016 05:40:29 GMT

Dear All,

Please find the below snap shot in QVW Pivot table date and columns are showing well, while exporting the data into excel formatting was changing as below.

Please suggest how to do.......

Re: Excel formating in Nprinting

harishkumarg — Sat, 29 Oct 2016 05:29:41 GMT

Can you share the data type of Year field. If possible the dashboard.

Regards

Harish

Re: Excel formating in Nprinting

Anonymous — Tue, 01 Nov 2016 06:21:28 GMT

We have created YEAR in Script level as below.

Yearname((Date(Date#(Datefield,'DD MMM YYYY'),'DD-MMM-YYYY')),0,4) as YEAR

Re: Excel formating in Nprinting

Anonymous — Tue, 01 Nov 2016 13:45:48 GMT

Hi,

By default, Nprinting excel format will use the number for date, year type, I think it process the year "2013-2014" as a date format, that is why you see the number.

For your case, you need to change the "Format cells" in the nprinting excel template as "text", then you can get the correct value.

Zhihong

Re: Excel formating in Nprinting

harishkumarg — Wed, 02 Nov 2016 07:27:41 GMT

Can you please tell me the format for the dimension in the chart?

Regards

Harish

Re: Excel formating in Nprinting

harishkumarg — Wed, 02 Nov 2016 17:59:23 GMT

Can you try by changing your dimension as Text(YEAR)

Regards

Harish

Re: Excel formating in Nprinting

harishkumarg — Thu, 03 Nov 2016 03:51:04 GMT

Did this help?

Regards

Harish

Re: Excel formating in Nprinting

vardhancse — Thu, 03 Nov 2016 04:00:03 GMT

Hi,

Try changing the format of YEar in N Printing excel template

Re: Excel formating in Nprinting

Anonymous — Mon, 07 Nov 2016 12:07:29 GMT

Thanks for your Reply...

i have changed the Nprinting excel template as Text format. even though i am getting same.

My object is Pivot table. need to be eliminate the space in excel output.