I have a table in NPrinting Excel
I have 2 columns
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
Please post a screenshot of the template or share the file.
refer to this help site page https://help.qlik.com/en-US/nprinting/February2019/Content/NPrinting/ExcelReports/Make-Calculated-Co...
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.
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.