Qlik Community

Ask a Question

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
Live chat with experts, bring your API Integration questions. June 15th, 10 AM ET. REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
muslikhahmasbah
Partner
Partner

Pivot in Nprinting Report

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

Labels (2)
1 Reply
Lech_Miszkiewicz

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-st...

 

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....

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.