4 Replies Latest reply: Sep 6, 2016 10:23 AM by xavier hemelaar RSS

    Time Stamp is changing with pptx export

    xavier hemelaar

      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