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

[Lech_Miszkiewicz]

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:

1. 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;

2. Create a straight table
   1. Dimensions:
      1. Dim1
      2. [Transaction Date]
   2. Measures
      1. Sum(Value)
3. Connect this app to NPrinting, regenerate metadata and create Excel based template
4. 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
5. Drag and drop it to excel sheet and convert it to "Table" (select range of cells->Insert-> Table)
6. 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
7. 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.
8. I Used colours to indicate where each of those goes
9. Preview as XLS and "Voila" - I get what I wanted:
10. 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:
11. I checked regional setting on server etc.. I have no idea how to fix this
12. 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 

[Ruggero_Piccoli · Accepted solution]

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

[Lech_Miszkiewicz]

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

Ciao!