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.
No I am not using not suported objects. I know that objects such as pivot table are not supported as such (only as image). Thus, I created formulas and calculated fields in Nprinting.
In my example, I want to calculate the daily number of covers per month in a restaurant. In order to do so, I created a formula for my number of days in a specific month, another formula for my number of covers in that same month and finally a calculated field that divides the number of covers by the number of days.
The result I want for january is 528 which is the result of 10568/20
However, if I don't add 10568 and 20 in my table because I only want 528 in january, here is what's hapenning:
If so, I think this is unfortunatelly "working as designed" and I believe for the calculated column to work in template the components used in calculation need to be also added to the template. They dont have to be visible, but must be added for calculation to work.
I am not a big fan of using such solution though as it is hard to maintain, has performance impact and it is difficult to debug. My suggestion would be to create dedicated object directly in Qlik Sense with all the required columns and use them as a source.
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.
I am indeed referring to the feature you are mentionning.
It is a lot of work but this is the only way to get the design I want with a table.
Here is an example of what I need to do:
This is easily done with Qlik Sense via Pivot Table. Unfortunately, as far as I know, pivot table are not supported as object in Nprinting and can only be used as image which forces me to create a a table with 1 column per month and then to create 1 formula per month for sales and 1 formula for cost per month (through set analysis), and finally 1 calculated field per month for profit (sales-cost).
I haven't found any other way, I would gladly accept your guidance.
That is exactly what you need to do with any NPrinting report (for your specific requirement) in which you need data that exist in a Pivot table....convert it to a straight table and use the straight table in your NP report. Its simply not possible to expand the individual columns/field data for use in your reports. To see this you can add your Pivot Table to and excel report and add straight table to the same excel report.
The pivot table cannot be expanded where as the straight table can. In turn then you can use the individual fields in any NP MS office, HTML and PxP (pixel perfect) report.
We are just 'like' you and like to be liked when providing a helpful answer. You may also press the 'Solution Accepted' button if an answer provided resolves your question or issue... Cheers!