Using Execl formula in NPrinting

boopeshj — Wed, 08 Aug 2018 08:32:10 GMT

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.

Editing after generation

Let me know if this possible.

Thanks in advance for your help.

Re: Using Execl formula in NPrinting

boopeshj — Thu, 09 Aug 2018 09:08:46 GMT

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

topic Re: Using Execl formula in NPrinting in Qlik NPrinting

Using Execl formula in NPrinting

Re: Using Execl formula in NPrinting