Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
srilakshmi_as
Creator
Creator

NPrinting 17 Repeat function for all rows

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

 

 

Labels (1)
1 Solution

Accepted Solutions
Daniel_Jenkins
Specialist III
Specialist III

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.

 

View solution in original post

10 Replies
Ruggero_Piccoli
Support
Support

Hi,

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

Best Regards,

Ruggero



Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
srilakshmi_as
Creator
Creator
Author

please find the attachment

Ruggero_Piccoli
Support
Support

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



Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
srilakshmi_as
Creator
Creator
Author

Hi Thanks fro the response.

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

Ruggero_Piccoli
Support
Support

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.

Native Excel Table with Hyperlinks.png

Best Regards,

Ruggero



Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
srilakshmi_as
Creator
Creator
Author

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
Creator
Creator
Author

Please find the the generated excel output.

srilakshmi_as
Creator
Creator
Author

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

Daniel_Jenkins
Specialist III
Specialist III

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.