I have a Qlikview sheet that is pulling in from a SQL source. I know that if an xls is used, you can format and extract the month, quarter and year in your LOAD statement. I was wondering if there was a way to do this when using a SQL statement.
Any help is greatly appreciated.
There's no difference to doing it when reading from Excel:
Month(Date) AS Month,
Year(Date) AS Year,
QuarterName(Date) AS Quarter,
Hope this helps,
Retrieving data ...