how to get the sum of previous months value in qlik sense

[#1]

Hi All,

how to get the sum of previous months value in qlik sense.

Requirement:  in the master table I have Available Hrs Column and Details table I have Month and Hrs Used

i need the sum of previous months value

Ex: in April I need total of JAN+FEB+MAR of Hrs Used

[vinieme12]

Create a MonthNumber field example Jan =1 , feb=2 

and in your expression

Sum({<Year = {2017} , MonthNum = {"=MonthNum<Max(Total MonthNum)"}>}HrsUsed)

[#3]

Thank you for your reply Vineeth.

I have created field [Month Number] but I am not getting accumulated values

in this example for company 1 system is showing 0 instead of 3.17

[vinieme12]

please post a sample

[ahaahaaha]

Hi,

As an variant, can be as in an attached file?

Regards,

Andrey