Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qlikers,
I have a problem with one of my chart when I want to export it to powerpoint. On the chart below you can see that I have normal date format (DD/MM/YYYY). I'm using the fonction "continous scale" that allow me to see my entire chart.
When I use the export to powerpoint this is what I get:
As you can see the date format is changing by adding the time after the date. How can I remove that?
I tryed in Main:
SET DateFormat='DD/MM/YYYY';
// SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';
SET TimestampFormat='DD/MM/YYYY';
and also in my load I did this:
DATE(FLOOR(Timestamp#([date import])),'DD/MM/YYYY') AS [date import],
But I still have the problem during powerpoint export....
Thanks for your help
Within the chart, try using Date() in the actual expression syntax, i.e. overriding the chart formatting. I've done this successfully in QlikView to Excel before but never tried Sense to PowerPoint.
In your load do simply this:
DATE(FLOOR([date import])) AS [date import],
Keep in mind that Date(Floor(timestampDate)) will transform the time of the timestamp to 00:00:00. Maybe if you use
date(right([date import], 10), 'DD/MM/YYYY') as [date import]
in a preceding LOAD you'll get what you want Or if you want everything in the same expression do as follow:
date(right( DATE(FLOOR([date import])) , 10), 'DD/MM/YYYY') as [date import]
Good luck
Regards,
MB
Hi,
I tried it with also some variants but nothing changes. I found a post with some else that has the same issue. But no solution for now. Maybe this is a bug that need a fix for next version ...
Thanks for your help
Hi,
I tried your solution in the script and also in my dimension but I still have the problem during conversion to powerpoint. Looks like Qlik isn't taking into acount my date format but using a specific setting during conversion.
Is there a member from Qlik Staff that can tell if this is a known bug? Or if there is a solution ?
thanks for your help!