topic Re: NPrinting - Excel Template - Table Object - Add the calculated column in Qlik NPrinting

NPrinting - Excel Template - Table Object - Add the calculated column

Mon, 17 Apr 2017 18:45:06 GMT

I am using NPrinting 16.3 and would like to use calculated columns as I see here:

Add the calculated column

Select the first cell on the right of the field tags.

Insert the formula =[@[Total Sales]]-[@[Gross Profit]].

Excel will automatically add this new column to the table.

Add Cost as a column heading.

https://help.qlik.com/en-US/nprinting/17.3/Content/ExcelReports/HowMakeCalculatedColumnExcelReports/Make-Calculated-Colu…

How can I use this kind of feature with Right() Excel function choosing part of adjacent column in excel template

and table object Not using Levels but table object and have it populated for all rows.

Thanks,

Amko

Re: NPrinting - Excel Template - Table Object - Add the calculated column

Lech_Miszkiewicz — Mon, 17 Apr 2017 23:54:15 GMT

please attach your xls template and maybe xls with what you are trying to achieve. That would help recognise your problem better.

on the other hand i am not sure whether you can refer to table object as such. Excel calcualtion is done on row level so creating new calculated column has be done on the same level.\

regards

Lech

Re: NPrinting - Excel Template - Table Object - Add the calculated column

Tue, 18 Apr 2017 09:05:28 GMT

If I use =right(B2,2) function in my Excel template Table Object
only first row in Column C gets populated as a result of excel formula not all rows

How can I get all rows in Column C to be populated?

Column A	Column B	Column C
Vendor	Week	Year
HP	W35-16	16
HP	W35-13
HP	W36-16
HP	W36-16
HP	W37-17
HP	W37-16
HP	W38-15
HP	W38-16
HP	W39-14

Thanks

Re: NPrinting - Excel Template - Table Object - Add the calculated column

Anonymous — Tue, 02 May 2017 21:42:00 GMT

Not sure what you're asking.

It seems to work fine for me to just put it within a level.