NPrinting 17 Repeat function for all rows

[srilakshmi_as]

Hi All,

I have a table in NPrinting Excel

I have 2 columns

1.No 

2.Link to no(Hyper link value)

I basically need No itself as the link (Dynamic value)

so i am using =Hyperlink(LinkValue,No)

above working only for 1 row n not repeating  , i tried 

=HYPERLINK($C$5:$C$26,$I$5:$I$26)     C column has Link value, I Column has no

Can any one help me to acheive this

[Ruggero_Piccoli]

Hi,

Please post a screenshot of the template or share the file.

Best Regards,

Ruggero

[srilakshmi_as]

please find the attachment

[Ruggero_Piccoli]

refer to this help site page https://help.qlik.com/en-US/nprinting/February2019/Content/NPrinting/ExcelReports/Make-Calculated-Co...

[srilakshmi_as]

Hi Thanks fro the response.

I need to do in table but not with levels, can  it be achievable

[Ruggero_Piccoli]

Hi,

Create a native Excel table like the one in the picture and add the hyperlink formula in a new column. Qlik NPrinting will expand the table and fill the column with the formula.

Best Regards,

Ruggero

[srilakshmi_as]

Hi Ruggero,Thanks for the response,

I have been trying the similar way.

I attached designer as well as output excel..

I also tried hyeprlink with =HYPERLINK($C$5:$C$6,$I$5:$I$6) and no luck.

[srilakshmi_as]

Please find the the generated excel output.

[srilakshmi_as]

Tried with @fieldname it gives an error ,kindly fine in the attachement

[Daniel_Jenkins · Accepted solution]

Hi,

From your screenshots it does not look like you have created the Excel native table correctly. Take a look at the attached video.

HTH - Daniel.