Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

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

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

4 Replies
vinieme12
Esteemed Contributor II

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

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

and in your expression

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

Not applicable

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

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

Capture.JPG

vinieme12
Esteemed Contributor II

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

please post a sample

ahaahaaha
Honored Contributor

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

Hi,

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

Regards,

Andrey