Discussion Board for collaboration on QlikView Layout & Visualizations.
Ive just started creating dashboards and wondered if there is a easy way to convert data thats in DD/MM/YYYY format to individual Day, Month and Year fields?
Thanks in advance
Go to Solution.
In a preceding LOAD to your SQL Select statement, you can use all QV date and time functions available, so something like this should do what you want:
LOAD [Date logged],
day([Date logged]) as Day,
month([Date logged]) as Month,
year([Date logged]) as Year;
SQL SELECT `Date logged`
Thank you for the quick response, That worked perfectly!!