topic Re: NPrinting 17 Repeat function for all rows in Qlik NPrinting

NPrinting 17 Repeat function for all rows

srilakshmi_as — Sat, 16 Nov 2024 04:01:57 GMT

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

Re: NPrinting 17 Repeat function for all rows

Ruggero_Piccoli — Wed, 27 Mar 2019 13:49:18 GMT

Hi,

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

Best Regards,

Ruggero

Re: NPrinting 17 Repeat function for all rows

srilakshmi_as — Thu, 28 Mar 2019 04:49:36 GMT

please find the attachment

Re: NPrinting 17 Repeat function for all rows

Ruggero_Piccoli — Thu, 28 Mar 2019 09:09:43 GMT

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

Re: NPrinting 17 Repeat function for all rows

srilakshmi_as — Thu, 28 Mar 2019 12:13:58 GMT

Hi Thanks fro the response.

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

Re: NPrinting 17 Repeat function for all rows

Ruggero_Piccoli — Thu, 28 Mar 2019 13:42:48 GMT

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

Re: NPrinting 17 Repeat function for all rows

srilakshmi_as — Fri, 29 Mar 2019 05:25:35 GMT

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.

Re: NPrinting 17 Repeat function for all rows

srilakshmi_as — Fri, 29 Mar 2019 05:26:33 GMT

Please find the the generated excel output.

Re: NPrinting 17 Repeat function for all rows

srilakshmi_as — Fri, 29 Mar 2019 05:40:19 GMT

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

Re: NPrinting 17 Repeat function for all rows

Daniel_Jenkins — Fri, 29 Mar 2019 07:53:40 GMT

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.

Re: NPrinting 17 Repeat function for all rows

srilakshmi_as — Fri, 29 Mar 2019 08:42:04 GMT

oh great thankyou..Daniel..its working now 🙂

@ Ruggero, sorry i assumed the table i created as excel native table.