Add an excel formula (VLOOKUP) in the NPrinitng report

[kmendes]

I have an NPrinitng report scheduled to be sent every week to my partners but in ton this report I don´t have a column assigning the row to a specific person for having action.

I would like to add in the NPrinting template a VLOOKUP formula to assign a name person for having action with that item/row. When I add the formula in the Excel template, is applied to the blank row and not to the rows with data.

I have tried some guidance that did not work.
Any thoughts?

[andregas]

Hello @kmendes ,

Can you post an example of your template, or some images?

Generally the Excel formulas work in NPrinting if you apply them to a range. You should start it from the cell with NPrinting tag and stop one cell over. You can use the tag <delete_row> to delete the blank row.
Here an example:

Regards

[kmendes]

In the column with the data, I have added the field name"<Division>"

I have added the formula in the last column (using IF formula)

But when I run the preview, the formula is not working bringing the division value to the blank cells

[Lech_Miszkiewicz]

You need to convert range of cells in excel to excel table as explained in documentation:

https://help.qlik.com/en-US/nprinting/May2022/Content/NPrinting/ExcelReports/Make-Calculated-Column....

also make sure that “expand range” is enabled for that entity table in Nprinting designer

[kmendes]

Following the guidance in the link :

1. Added the table

2. Select the field and set up as a table

3. Added a column with the IF formula

4. When I run the preview, the formula is calculating the blank rows.

Maybe I´m not following correctly one of the steps above.

[andregas]

Pay attention that you insert tag column <division> in multiple rows, that crete multiple export of the same set of data.

In addition, are you sure that the column tags are part of the same table? Because Division2 column start when country end. And why the filed name in the template was Division and in the report generated became Division2?