Hello all,
I am trying to execute a scrip and when I reload it it gives the following error:
ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: Conversion failed when converting the nvarchar value 'Mar' to data type int.
The sql runs fine in the database.
Below is the sql select statement:
SQL SELECT
ac.Month,
ac.CalendarYear,
c.FiscalYear as FiscalYear,
c.FiscalPeriod as FiscalPeriod,
c.FiscalQtr as FiscalQtr,
ac.Month,
ac.Entity,
ac.PTInitialEval,
d.System as System,
d.Division as Division,
d.Location as Location
from dbo.XYZ_ ac
join dbo.Calendar c
on c.Month = ac.Month
and c.Year = ac.CalendarYear
join dbo._DivisionCrossWalk d
on d.Entity = ac.Entity
order by FiscalYear
,FiscalPeriod
I am very new to qlikview and not sure where the problem is in the script.
Thanks,
Swati
