Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
IMPORTANT: PLEASE READ - Labels will be required in the NPrinting forum starting on Friday September 26, 2019: Click here for details and instructions.
Highlighted
Partner
Partner

Using Execl formula in NPrinting

Brief :

I have a table with multiple columns. This is just an example. I would like to dynamically display the number of characters in one of the column for all rows.

Example :

"Col1 Summary" is from table from Qlikview source.

Length : is what I am looking for as output.

I want NPrinting output Excel to have the formula mentioned in col B to have calculated until the end of rows in my table.

This formula should be in the excel so that it could calculate dynamically when users add text in Excel post the generation.

Generation.PNG


Editing after generation

   Post Generation Edit.PNG

Let me know if this possible.

Thanks in advance for your help.

1 Solution

Accepted Solutions
Partner
Partner

Re: Using Execl formula in NPrinting

I was not unchecking/unselecting the expand range on the table properties. Which caused the value or formula to cell's to disappear.

1 Reply
Partner
Partner

Re: Using Execl formula in NPrinting

I was not unchecking/unselecting the expand range on the table properties. Which caused the value or formula to cell's to disappear.