Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bohravanraj
Partner - Creator II
Partner - Creator II

Urgent : total of last 12 Month at back end

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:

DatePlantMaterial

Value

regards,

Urgent

3 Replies
MK_QSL
MVP
MVP

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
Partner - Creator II
Partner - Creator II
Author

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,