Urgent : total of last 12 Month at back end

[bohravanraj]

Dear Folk,

Please can any body suggest me how to calculate sum of Last 12 month value at a back end where i am having field:

Date

Plant

Material

Value

regards,

Urgent

[MK_QSL]

Test:

Load

     Date,

     Plant,

     Material,

     Value

From YourFileName;

Load

     Plant, Material, SUM(Value) as TotalValue

Resident Test

Where Date >= AddYears(Today(),-1) and Date <= Today()

Group By Plant, Material;

[bohravanraj]

Dear Manish, I am having a data for last 5 year ,

so how can we do it for last 5 Years,

it will onl do for Current Month & Year,

[MK_QSL]

use this...

http://community.qlik.com/docs/DOC-4252