topic Re: Excel formulas Nprinting - Excel Developer tool in Qlik NPrinting

Excel formulas Nprinting - Excel Developer tool

jsobrinho — Mon, 17 Feb 2020 17:58:21 GMT

Hi guys

-I need to enable the excel developer tool. In Excel, it is necessary to activate in the file> Options> Customize ribbon> Main tabs> Developer, where can I activate NPrinting?

-When I try to create an Excel formula from a TB10 column, an error appears, but when I did it in Excel, I was successful.

-Its possible use lists box from Qlikview in NPrinting?

Re: Excel formulas Nprinting - Excel Developer tool

Lech_Miszkiewicz — Tue, 18 Feb 2020 02:30:41 GMT

https://help.qlik.com - I suggest to always check there for answers first.

I need to enable the excel developer tool. In Excel, it is necessary to activate in the file> Options> Customize ribbon> Main tabs> Developer, where can I activate NPrinting?

What do you need it for? If you want to write macro do it in excel and then use it as a template. I have not seen support for Dev ribbon in NPrinting. You can also try using shortcut alt+F11. If you want to embed some OCX library objects i dont think they will be supported in NPrinting. You can take the same approach and build everything in excel as a template and then try to use this template to place NPrintning entity tags.

When I try to create an Excel formula from a TB10 column, an error appears, but when I did it in Excel, I was successful.

The way you build your report looks little bit strange. I am not sure what you are trying to achieve as you are entering whole Table as a entity tag into your template. Help.qlik.com explains how to use formulas with coresponding objects in excel. https://help.qlik.com/en-US/nprinting/November2019/Content/NPrinting/ExcelReports/Make-Calculated-Column.htm

Its possible use lists box from Qlikview in NPrinting?

be precise what you want to use it for - to answer your question I can say yes, we can use listboxes in NPrinting... but you can use listbox object only as an image. If you want to use it as a data you need to use field as a Level or Page or Cycle.

Re: Excel formulas Nprinting - Excel Developer tool

Ruggero_Piccoli — Tue, 18 Feb 2020 10:29:38 GMT

Hi,

You added TB10 as a table tag. If the original table hase more than 3 columns they will be written over column D, E, etc in the final report. In similar cases I suggest to insert the straight table column by column.

It is normal to have an Excel error in similar cases. The table tag <TB10> is interpreted by Excel as a string, if you insert it in a formula that needs a number (for example) Excel returns an error that disappears on the produced reports.

In any case, inserting Excel formulas in this way is not correct. @Lech_Miszkiewicz suggested you to read the correct way in the help site and I agree. You need to add the straight table column by column and insert an Excel table. Maybe, it depends on the situation and it is not clear at the moment, you need to disable the Expand Range option to keep the formula references.

If you want to insert Excel macros you must develop an .xlsm template and also select .xlsm as output format. It is the only template format that supports macros, and the VBA code is only copied from the source template to the output report. Macros are never executed by Qlik NPrinting.

In a node of the template treeview you can insert all and only the objects that you see when you do a right click on the node. For more details read https://help.qlik.com/en-US/nprinting/November2019/Content/NPrinting/ReportsDevelopment/Qlik-objects-supported-NP.htm

Best Regards,

Ruggero

Re: Excel formulas Nprinting - Excel Developer tool

jsobrinho — Sun, 01 Mar 2020 20:15:03 GMT

The solution was, first created all formulas in excel and after import this excel as template. thank you.