topic how to calculate sum for week,day ,month? In SQL SERVER in QlikView

how to calculate sum for week,day ,month? In SQL SERVER

Thu, 04 Sep 2014 03:56:57 GMT

how to calculate sum for week,day ,month?

In SQL SERVER

jagan — Thu, 04 Sep 2014 04:05:42 GMT

Hi Yogesh,

Try like this

For Week:

SELECT

DATEPART (wk, DateFieldName) AS Week,

Sum(Sales) AS Sales

FROM TableName

Group By DATEPART (wk, DateFieldName);

For Month:

SELECT

DATEPART (m, DateFieldName) AS Month,

Sum(Sales) AS Sales

FROM TableName

Group By DATEPART (m, DateFieldName);

For Day:

SELECT

DATEPART (d, DateFieldName) AS Day,

Sum(Sales) AS Sales

FROM TableName

Group By DATEPART (d, DateFieldName);

Regards,

Jagan.

jagan — Thu, 04 Sep 2014 04:06:11 GMT

Hi Yogesh,

Check this link it has various date formats

Regards,

Jagan.

Thu, 04 Sep 2014 04:07:53 GMT

hi jagan,

thanks...

please give anuy example you have?

jagan — Thu, 04 Sep 2014 04:14:10 GMT

Hi,

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.

Regards,

Jagan.