Unable to print alphanumeric and numeric values in single column in nPrinting

Sneha1 — Fri, 15 Nov 2024 22:26:48 GMT

Hello,

I am unable to print alphanumeric and numeric values in single column in nPrinting excel sheet. I tried

1) typecasting to Text in DB2 in QVD

2) wrote text(coulmn name) as Coulmn name while loading in QlikSense script

3) also while creating sheet tried writing =Text(Coulmn name)

4) Tried to format it to Text in Nprinting excel sheet.

None of above method worked.

The example of values are like
12345, AVF1234, 999999, 45GHB, FFFFRH

The excel output in nprinitng prints values of only one datatype in one column, but i want all the values in single column.

Re: Unable to print alphanumeric and numeric values in single column in nPrinting

Lech_Miszkiewicz — Tue, 23 Nov 2021 06:14:36 GMT

My understanding is that all values are still printed the only thing is that numbers are also exported as text which is working as designed.

The workaround I can think of may include excel functions. So you populate 1 column (for example column C) with text values all the way, you can hide that column and then use function like below to convert text to numbers where possible

cheers

topic Unable to print alphanumeric and numeric values in single column in nPrinting in Qlik NPrinting

Unable to print alphanumeric and numeric values in single column in nPrinting

Re: Unable to print alphanumeric and numeric values in single column in nPrinting