How to display the sales sum by year?

[#1]

the date format import to qlikview is YYYY-MM-DD, and the sales is linked to the date, how can I get the sum of sales by year, month, and week?

thank you!

[SunilChauhan · Accepted solution]

it so simple as you thing

Load

Year(date) as Year

sum(sales) as Sales

from [your table name]

group by date;

Cheers

Sunil

[#3]

Thank you!

I have completed the fields as this, follow you advices:

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

LOAD Date#(Date, 'DD/MM/YYYY') as Date,

     Year(Date#(Date, 'DD/MM/YYYY')) as Year,

     Customer,

     Sales

FROM

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~