topic Number Format not persisting to excel in Qlik NPrinting

Number Format not persisting to excel

mikeslade — Tue, 14 Apr 2020 07:07:35 GMT

Hi, could do with some help getting formatting correct, I can't seem to crack it!

I have a table in Qlik Sense app with a field year_week that is number format yyyyww - this is coming through to excel, but excel is showing number stored as text. I've tried overwriting the column format to number in the Nprinting designer, but I must be doing something wrong.

Does anyone have any suggestions? I'd like to avoid macro use ideally.

Thanks.

Re: Number Format not persisting to excel

Ruggero_Piccoli — Tue, 14 Apr 2020 08:24:39 GMT

Hi,

Did you removed the Keep Source Format flag? With it activated the format settings you do in the template are not used.

Does the original Qlik Sense app column has a Text() formula that force the output to be text?

Best Regards,

Ruggero

Re: Number Format not persisting to excel

Lech_Miszkiewicz — Tue, 14 Apr 2020 09:29:03 GMT

How do you create this field in Qlik Sense. Is this a concatenation of 2 fields which would result in ASCII text output?

thanks