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.
Re: NPrinting 17 PixelPerfect chart date dimension
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
This filter includes only 1 month
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:
Click on Axis
Select the Labels tab
Select the Auto tab on the top
Select the format you prefer from the list
Click on Add to apply the format
If you like set other options for the labels. In this example I rotated them of 90 degrees
Run a preview
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.