Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Table and Image filtered objects are not supported directly in the NPrinting Pixel Perfect editor unfortunately.
These types of filters are a supported feature using the NP MS Office and HTML template editors however.
You may wish to consider using one of those template editors to meet your requirement then use PDF as an output format when you add this report to a publish task.
Hope this helps
Kind regards...
Hi Frank,
Thanks for your quick response. I'll try to make it in NP Ms office / HTML and use the output as a PDF report.
Let you know the status.
Regards,
Vara
Or you may want to create a dedicated object for your table which could be filtered from report /task level without affecting other objects (for example with use of set analysis and island tables, or If you wait for November 2019 version with variable filter...
Hi Frank,
I did hardcoded three tables in Qliksense with respective of filters (Uptime, Resolution, Other) with calculated dimensions, made some expressions for Red color text values and percenatge(%) symbols which output is getting in Excel type of format in Nprinting, but the thing is getting below mentioned issues.
1. not getting proper alignment,
2. Not getting borders for field values
3. The headers, logos and striaght table fields are not repeating in continues pages.
4. Not getting images dynamically in Nprinting reports.
Request you to please look into these issues and help me out on this.
thanks a ton in advance.
Regards,
Vara
It's my weekend now but I was really interested in taking on this challenge so here is what you can do.
Since you can't use chart filtering in pixel perfect and also since you can't put charts side by side anyway, I found a workaround that will require that you create a single QS chart with can be used with your PxP report.
Now you have a single chart with 3 separate years that can be used in your pixel perfect report. (Note: Please remember to reload your NPrinting Connection to this Qlik Sense app before proceeding so that the new fields will become available to NPrinting).
So create your PxP report as usual using this newly created chart.
I have attached a copy of the QVF I created today as well as a sample report generated from this QVF with repeating headers and page breaks using group headers (repeat on every page check box option selected) and footers (break after the page option selected)
Hope this is a method that will work for you...unless someone else hear has a better option to help you to meet your requirement.
Kind regards....
Here is the report output as well.
You can used the Pixel Perfect editing tools to edit to your hearts content.
Hi Frank,
I sincerely thank you for your kind response on my query.
The fields i am using in Qliksense straight tables are already calculated fields and fetching from the data base directly.
we no need to do any transformations of these fields in QS App.
I have done hard coded one each and every table (3 tables) and puling to excel format in Nprinting.
but while converting into pdf report, the report is not getting with proper borders, headings and field names are not repeating into continues pages.
The major issue is that how to get dynamic images in Nprinting based on our selections.
Regards,
Vara
dynamic images was answered here:
and here
both seem to be duplication of the same post as well as this post.
Please try to focus on one topic at the time as community will not be able to benefit from topics created to solve multiple issues..
If you want to learn how to use dynamic images ask the question related to it, If you want to learn how to make sure the borders are properly created make separate question re this and provide sample/detailed screenshots of your template as this is where you are doing something wrong (read instructions on help.qlik.com which describes how properly built report template needs to look like)
https://help.qlik.com/en-US/nprinting/June2019/Content/NPrinting/ExcelReports/Excel-formatting.htm
when createing q question please spend time describing steps you are taking... screenshot your template, screenshot xls output, screenshot pdf output.
You are asking about borders not being populated in PDF...are they at least populated in XLS output?
regards
Lech