topic Re: Datepart in QlikView

Datepart

Tue, 02 Apr 2013 16:26:32 GMT

What am I doing wrong here???

I'm trying to create a YearMonthName field. First 2 work ok, but the 3rd one does not. Can someone help.

Thanks

DatePart(month, search_Incident_Custom_Joined.DateRaised) as Month,
DatePart(year, search_Incident_Custom_Joined.DateRaised) as Year,
DatePart(year,search_Incident_Custom_Joined.DateRaised) & DatePart(Month,search_Incident_Custom_Joined.DateRaised) as YearMonthName

Re: Datepart

Gysbert_Wassenaar — Tue, 02 Apr 2013 16:32:00 GMT

Datepart is not a qlikview function. If you want help with regards to the SQL Server T-SQL dialect I recommend you ask on a forum that specializes in T-SQL

Re: Datepart

Tue, 02 Apr 2013 16:34:50 GMT

how come these work ok and the other one doesn't?

DatePart(month, search_Incident_Custom_Joined.DateRaised) as Month,

DatePart(year, search_Incident_Custom_Joined.DateRaised) as Year,

Re: Datepart

Gysbert_Wassenaar — Tue, 02 Apr 2013 16:39:15 GMT

Ah, let me try that again :

Datepart is not a qlikview function. If you want help with regards to the SQL Server T-SQL dialect I recommend you ask on a forum that specializes in T-SQL

Re: Datepart

Tue, 02 Apr 2013 16:41:40 GMT

As I'm posting in the NEW to QlikView forum perhaps you could be a little bit forgiving!

Re: Datepart

kaushiknsolanki — Tue, 02 Apr 2013 16:45:01 GMT

Hi,

You can create those fields using below script.

Load *,

Month(DateRaised) as Month,
Year(DateRaised) as Year,
Monthname(DateRaised) & MonthYear;

Sql Select * from search_Incident_Custom_Joined;

Regards,

Kaushik Solanki