Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
DiegoF
Creator
Creator

NPrinting Excel Dynamic table gets lost by using calculated fields

Hi, I´m trying to make a dynamic table in which I have to put a calculated field. It does the job right, the table is ok with the information as it should be, but when I open the Excel (on demand), it tells me the property of dynamic table had to be removed because integrity problems, so I just have a normal table that looks like a dynamic table but the information is correct.

 

I want it to keep it a dynamic table with the calculated field, but I´m guessing it´s not possible, because the calculated field is trying to work with references after all, and then it looses his dynamic property or smth and thats why it shows correct, but at that cost.

 

Any ideas if it´s possible? Or am I doing something wrong?

Labels (2)
1 Solution

Accepted Solutions
DiegoF
Creator
Creator
Author

OK, Nevermind, I did it again from scratch and it´s working. I guess in my last template I touched so many things that the lost of the pivot property was probably about other reason.

 

Sorry for the inconvenience and thanks for the assist.

View solution in original post

7 Replies
Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

 

you are correct - it is not really supported but obviously it depends how you built your nprinting template.

Exporting your table as an image or whole table tag should still work though. More info on:

"https://help.qlik.com/en-US/nprinting/May2021/Content/NPrinting/ReportsDevelopment/Qlik-objects-supp...

 

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
DiegoF
Creator
Creator
Author

I mean, it´s just a normal table that has 2 columns i want to use for the calculated field in the dynamic table, it´s nothing crazy. It´s just to put the average price as a calculated field, by dividing this two columns and showing the result for each row, a simple math. 

 

So I really can´t do much with this problem? I´m always going to lose the dynamic property or is it a way around? Because I could have the average price in the normal table and pass it to the dynamic table, but then I don´t want to resume this value in the pivot table as a sum or product and all that, because I´ve already made the operation in the normal table and now I´m just forcing to operate that values and I don´t want that, I don´t know if I´m explaining.

 

Thanks in regards.

Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

Words like "normal table", "dynamic table" can be interpreted in so many ways that it is still hard to understand what you are doing. I understand that measure mathematically is simple and there is no rocket science but i still dont know what you are doing. 

Imagine that in order to provide you with the answer i need to be able to recreate all steps you are taking.

Have a look at this topic to see how to describe steps in the community topics including all steps you taking so we can replicate it easily ( you may include screenshots and all steps from expressions in Qlik to how your NPrinting template looks like).

https://community.qlik.com/t5/Qlik-NPrinting-Discussions/Chart-Legend-containing-Date-has-different-...

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
DiegoF
Creator
Creator
Author

Ok sorry, I did use different terms but I meant the same thing, I´ll try to re explain appropriately . I have this normal table (the table that you get when you convert to table on the insert label):

DiegoFraj_0-1646385683737.png

Then, I resume this table to pivot table:

DiegoFraj_1-1646385861639.png

And now I`m inserting a calculated field by calculating the division between price/cuantity:

DiegoFraj_2-1646386082363.png

DiegoFraj_3-1646386143158.png

 

And my template looks like this:

DiegoFraj_4-1646386194635.png

So when I download the Excel with the real values, it has this table, with the correct values and calculations, but it tells me that it removed the pivot table (I´m guessing the funtionality of pivot tables) and it shows me this pivot table but in reality, it´s just a normal table with the appearance of a pivot table, because you can´t interact with the "pivot" table, you can´t filter and expand and all that, it´s just, a normal table that looks like a pivot table.

DiegoF
Creator
Creator
Author

OK, Nevermind, I did it again from scratch and it´s working. I guess in my last template I touched so many things that the lost of the pivot property was probably about other reason.

 

Sorry for the inconvenience and thanks for the assist.

Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

All good - I am glad it is working for you.

Cheers

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
Ruggero_Piccoli
Support
Support

Hi,

Having the DIV/0 error in the template is ok and it will be removed in the generated table with real data.

Please remember to set the following two pivot table option:

Ruggero_Piccoli_0-1646388759837.png

Detailed instructions https://help.qlik.com/en-US/nprinting/May2021/Content/NPrinting/ExcelReports/Pivot-table-Excel.htm

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.