Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Create a MonthNumber field example Jan =1 , feb=2
and in your expression
Sum({<Year = {2017} , MonthNum = {"=MonthNum<Max(Total MonthNum)"}>}HrsUsed)
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
please post a sample
Hi,
As an variant, can be as in an attached file?
Regards,
Andrey