topic Yearwise Data in QlikView

Yearwise Data

Mon, 19 Sep 2011 05:04:32 GMT

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.

Yearwise Data

Jason_Michaelides — Mon, 19 Sep 2011 06:54:11 GMT

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

Yearwise Data

Mon, 19 Sep 2011 09:26:16 GMT

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

Regards,

Jeeva.

Yearwise Data

Jason_Michaelides — Mon, 19 Sep 2011 09:46:33 GMT

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

Yearwise Data

Mon, 19 Sep 2011 09:52:58 GMT

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.

Yearwise Data

Jason_Michaelides — Mon, 19 Sep 2011 10:45:05 GMT

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

Jason