Discussion Board for collaboration related to Creating Analytics for QlikView.
how to calculate sum for week,day ,month?
In SQL SERVER
Try like this
DATEPART (wk, DateFieldName) AS Week,
Sum(Sales) AS Sales
Group By DATEPART (wk, DateFieldName);
DATEPART (m, DateFieldName) AS Month,
Group By DATEPART (m, DateFieldName);
DATEPART (d, DateFieldName) AS Day,
Group By DATEPART (d, DateFieldName);
Check this link it has various date formats
please give anuy example you have?
Check this in your database tables, if you want to practice download Northwind or Pubs or Adventureworks database and practice.
Please close this thread by giving correct and helpful answers to the useful posts.