Pivot in Nprinting Report

muslikhahmasbah — Fri, 12 Feb 2021 15:46:33 GMT

I am not able to do data reference from a pivot in NPrinting.

The pivot contain column that have long formula for aging.

I received below error when i try to do data reference.

"Text values in formulas are limites to 255 characters. To create loongre text values in a formula, use the Concatenate function or the concatenate operator (&)"

Seeking expertise advice here.

Thank you

Re: Pivot in Nprinting Report

Lech_Miszkiewicz — Sat, 13 Feb 2021 00:02:55 GMT

This is not NPrinting issue!!!

it is well known and widely described excel single cell limitation.. some examples in links below:

https://www.mrexcel.com/board/threads/formula-character-limit.460599/

ot here:

https://stackoverflow.com/questions/12386414/excel-use-formula-longer-that-255-characters

or here:

https://stackoverflow.com/questions/43524741/excel-formula-limitation-with-255-characters-with-if-statement

Depending on your use case there is a lot what can be done, but If you want us to give yo umore advice it will require your to provide us with everything needed to replicate this issue so we could test it in our own environmnets. Some sample app, maybe export of the template, screenshots etc....

topic Pivot in Nprinting Report in Qlik NPrinting

Pivot in Nprinting Report

Re: Pivot in Nprinting Report