topic Re: Excel formulas not working when using on demand reporting in Qlik NPrinting

Excel formulas not working when using on demand reporting

Jakub_VO — Sat, 16 Nov 2024 00:33:01 GMT

@Lech_Miszkiewicz as you have suggested I have reworked my question:

I have encountered following issue when working with NPrinting and ondemand button (Qlik Sense November 2019)

on my XLS report in one of the tables I have added excel formula =[TEST_YY]+2 when i generate report with preview button, formula is working fine, but when I go to dashboard and use on demand reporting, then instead of calculations I get =#REF!+2

To test it you can make following script (thanks to @Lech_Miszkiewicz )

Test:
Load
TEST_YY,
TEST_XX

Inline
[
TEST_XX, TEST_YY
43939, 439
43939, 439
43940, 440
43942, 441
43950, 442
43950, 442
43951, 443
43955, 444
43959, 445
]
;

exit script;

Make a straight table with 2 dimensions:

Connect this app to NPrinting, regenerate metadata and create Excel based template

Add table to your Table tags

Drag and drop it to excel sheet and convert it to Table

Add additional column with formula =[TEST_YY]+2

Now, when using preview button the result is following:

But when using ondemand button on dashboard resulted table looks like that:

I have also checked when creating a report with NPrinting tasks resulted table looks like on preview so problem is only with ondemand reporting.

Re: Excel formulas not working when using on demand reporting

Lech_Miszkiewicz — Thu, 04 Jun 2020 06:14:58 GMT

Hi @Jakub_VO

I tested this in my environment on NPrinting April 2020 and it is all working fine without issues.

In this case you may want to provide detailed description of how you build your template. Also make sure you provide screenshots so we can see if/how you use below settings for table used as a source:

"Keep Source Formats"
"Expand Range"
Also make sure you describe steps on how you create your named table so you can use referenced formulas like yours.
last very important thing is to always choose correct label for software you are using. Your generic label "Qlik NPrinting" does not help as each version is very different and has different features.

see this topic to get an idea how to prepare description of your problem so we can replicate: https://community.qlik.com/t5/Qlik-NPrinting-Discussions/Chart-Legend-containing-Date-has-different-value-when-output-is/td-p/1705871

The better you describe your problem the quicker you may get an answer how to fix it.

cheers

Re: Excel formulas not working when using on demand reporting

Lech_Miszkiewicz — Thu, 11 Jun 2020 10:31:44 GMT

Hi @Jakub_VO

I thing i noticed is that your named table gets "pushed down by other" objects.. So you create it in C69:E70 range and in your result preview it lands in different range C97:E104

Can you just try putting this table (only for testing at the top of your sheet)? like in row 1...

The other thing - and this something I am not sure is that I always create a named table with extra row and I add deleterow tag in this extra row.... (dont worry about arrows... just notice that my named table has range B1:D3 and deleterow tag...)

Re: Excel formulas not working when using on demand reporting

Jakub_VO — Mon, 15 Jun 2020 13:37:53 GMT

@Lech_Miszkiewicz just tested with table in first row and <deleterow> tag

See the result with ondemand reporting below:

So no change.

Re: Excel formulas not working when using on demand reporting

Lech_Miszkiewicz — Mon, 15 Jun 2020 23:31:26 GMT

Hi @Jakub_VO

I am out of options here. @Ruggero_Piccoli - what do you think, anything you can add or is this a subject for support case?

Re: Excel formulas not working when using on demand reporting

Ruggero_Piccoli — Tue, 16 Jun 2020 09:29:12 GMT

Hi,

Try to upgrade to June 2020. It has a similar issue fixed so I don't know if it is the same but they look similar.

Best Regards,

Ruggero