Discussion board where members can get started with QlikView.
Year(OrderDate) as Year,
Month(OrderDate) as Month,
Week(OrderDate) as Week,
Day(OrderDate) as Day,
'Q' & Ceil((Month(Addmonths(OrderDate,-3))/3)) as Quarter,
(UnitPrice*Quantity) as GrossRevenue,
((UnitPrice*Quantity) - ((UnitPrice*Quantity)*Discount)) as NetRevenue,
SQL SELECT *
FROM `D:\Test\Session 01\Data Sources\Nwind.mdb`.Invoices;
This table is taken from the popularly available NorthWind.mdb data source.
When i try to load these kind of fields. It giives me an error.
Go to Solution.
Thanx for reply Mr. Frankcrezee.
Sorry to bother, but got the solution. I actually did a silly thing by loading even the queries with the tables. QlikView loads only tables. I tried to peek into the Database & got the answer.