Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

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
Highlighted
Support
Support

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
Highlighted
Employee
Employee

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.
Highlighted
Contributor III
Contributor III

please find the attachment

Highlighted
Employee
Employee

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.
Highlighted
Contributor III
Contributor III

Hi Thanks fro the response.

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

Highlighted
Employee
Employee

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.
Highlighted
Contributor III
Contributor III

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.

Highlighted
Contributor III
Contributor III

Please find the the generated excel output.

Highlighted
Contributor III
Contributor III

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

Highlighted
Support
Support

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