Discussion board where members can get started with QlikView.
I have some XML files that I am loading into Qlikview. Here's a fragment from a node:
<Exclusion><StartDate>17/01/2003 00:00:00</StartDate><EndDate>24/01/2003 00:00:00</EndDate></Exclusion>
I've loaded them in but it looks like Qlikview is treating the date as a number rather than a proper date / time value - how should I format the XML so that Qlikview loads it properly?
Have you tried to format date after loading with date(xxxxxxx,"dd/MM/yyyy")
Do I need to do that in the loadscript, or in the QV designer?
In the loading
U can use this date(xxxxxxx,"dd/MM/yyyy") in both.
If u use this in QV designer, it creates performance issue.
If U use this in Load script , it increase the performance.