Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Yearwise Data

I have date and sales column in my DB. I want the sum(sales) in Yearwise. How to achieve it in Qlikview? Can anyone suggest me...

Regards,

Jeeva.

5 Replies
jason_michaelid
Honored Contributor II

Yearwise Data

Hi,

In your load script, add a field:

Year(Date) AS Year

Then in the chart put Year as the dimension and Sum(Sales) as the expression.  You could also put Year(Date) as the dimension in the chart but it's better in the script.

Hope this helps,

Jason

Not applicable

Yearwise Data

Ya i did like that, but i got the sum(sales) for the whole year.

Regards,

Jeeva.

jason_michaelid
Honored Contributor II

Yearwise Data

Isn't that what you wanted? If not, what do you mean by "Yearwise"?

Not applicable

Yearwise Data

I hav data for the year 2000 to 2010. Its in date format. For Eg. 1/1/2000 to 31/12/2010 sales data.I want to see it as yearwise total.I want the output as follows.

                      Year              Sales

          

                     2000                xxx

                     2001                yyy

                     2002                zzz

Regards,

  Jeeva.

jason_michaelid
Honored Contributor II

Yearwise Data

And your Sales figures should reflect the total sales for the year shown - correct?  If so then use the solution I posted earlier.

Jason

Community Browser