Chart Legend containing Date has different value when output is XLS and PDF

Lech_Miszkiewicz — Thu, 28 May 2020 03:02:46 GMT

Hi All,

This is something I came across by accident. I know workaround (but i don't like it since it makes everything else difficult like sorting on converting).

This particular example is on NPrinting April 2020 (there was no label for April 2020 when I create this post) and on Qlik Sense Feb 2020. I also checked on various different versions and issue is still there. So what is the issue? I am providing steps to replicate it:

Create Qlik application using below inline

Test:
Load 
	Dim1,
	Date(Date)			as [Transaction Date],
	Floor(Rand()*10000) as Value
Inline
	[
		Dim1, 	Date 
		A,		43979
		A,		43980
		A,		43981
		B,		43979
		B,		43980
		B,		43981
		C,		43979
		C,		43980
		C,		43981
	]
;


exit script;

Create a straight table
1. Dimensions:
  1. Dim1
  2. [Transaction Date]
2. Measures
  1. Sum(Value)
Connect this app to NPrinting, regenerate metadata and create Excel based template
Add table created in pt 2 to your Table tags
1. Here you can choose to disable "Keep source format", but i played with it with no change on final effect
Drag and drop it to excel sheet and convert it to "Table" (select range of cells->Insert-> Table)
As indicated using arrows I am doing it on Sheet1, I am formatting in Excel Transaction Date to date format and I have "Keep source format" disabled
Now I create Sheet2 and in this sheet i create a pivot table which will be a source of data for my Pivot Chart (Bar chart - stacked - horizontal). I made sure there is Chart element "Legend" added - as Legend is the problematic element.
I Used colours to indicate where each of those goes
Preview as XLS and "Voila" - I get what I wanted:
So I need this report as PDF, and here is a problem. When you run it to be created as PDF format of date in legend changes. I was not able to figure out why.. see screenshot:
I checked regional setting on server etc.. I have no idea how to fix this
My workaround so far was to completely convert [Transaction Date] field to text but this obviously has consequences like issues with sorting etc....

if anyone has an idea how to fix this I am more than happy to try anything.

@Ruggero_Piccoli - would you be able to suggest something?

Hope this makes sense.

regards

Lech

Re: Chart Legend containing Date has different value when output is XLS and PDF

Ruggero_Piccoli — Thu, 28 May 2020 10:25:27 GMT

Hi @Lech_Miszkiewicz ,

Based on my experience this seems an issue of the library that created the PDF. I suggest you to open a support ticket with a link to this conversation. Thanks for the detailed information.

I asked to the community manager to add the April 2020 label.

Best Regards,

Ruggero

Re: Chart Legend containing Date has different value when output is XLS and PDF

Lech_Miszkiewicz — Thu, 28 May 2020 10:47:06 GMT

I will open support case tomorrow. Thanks @Ruggero_Piccoli !!

Ciao!

topic Re: Chart Legend containing Date has different value when output is XLS and PDF in Qlik NPrinting

Chart Legend containing Date has different value when output is XLS and PDF

Re: Chart Legend containing Date has different value when output is XLS and PDF

Re: Chart Legend containing Date has different value when output is XLS and PDF