Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Qlik Community,
On the attached Excel file, it seems dates are reported as M/D/YYYY string - Capture1.
When trying Date#("Timestamp",'DD/MM/YYYY') as "Timestamp1" on the Data Load Editor, I get result as per Capture2.
How to get date range properly reported from 09/12/2023 to 08/01/2024?
Thank you,
Jose
Hello @Parthiban ,
It works! 🙂
On the Line Chart I have, I disabled Continues scale
And this is the result:
Thanks a million, it is really appreciated 🙂
Kind regards,
Jose
Hi,
Try this one
Date(date#(Timestamp,'M/D/YYYY'),'DD/MM/YYYY') as Timestamp1
Hello @Parthiban ,
It works! 🙂
On the Line Chart I have, I disabled Continues scale
And this is the result:
Thanks a million, it is really appreciated 🙂
Kind regards,
Jose