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: 
Anonymous
Not applicable

NPrinting 17 PixelPerfect chart date dimension

Hello,

I am developing a report with PixelPerfect and I need to do PixelPerfect native chart where date is dimension field. When I am using MonthYear as dimension, it is showing dimension correctly but when I am using Date field, it is converting dimension to MonthYear automatically. How to set date as dimension? Results, parameters and template file attached.

Best regards,

Riku Pilli

1 Reply
Ruggero_Piccoli
Support
Support

Hi,

I suppose you are working with Qlik NPrinting 16. The procedure with 17 is the same.

When you add a Data field as dimension without specifying the format you will have a different automatic format based on the number of records and available space.

This filter includes 3 months

010 month year.png

This filter includes only 1 month

020 yyyy-mm-dd.png

If you don't specify a format for the date field it is automatically select by Qlik NPrinting.

To set a format for the Date field:

030 settings.png

  1. Click on Axis
  2. Select the Labels tab
  3. Select the Auto tab on the top
  4. Select the format you prefer from the list
  5. Click on Add to apply the format
  6. If you like set other options for the labels. In this example I rotated them of 90 degrees
  7. Run a preview

040 result.png

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 as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.



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.