Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
pas_epm_support
Contributor II
Contributor II
‎2018-10-18 04:11 PM

How to get the LTM (Last 12 months) rolling calculation

Hi,

I am new to Qlik Sense. I need help regarding PRODUCT calculation in qliksense. My requirement is to get the Cumulative returns for the last 12 months for a particular selected entity.  

As per the excel sheet below , i have to get the Cumulative value for Monthly Returns(net or gross). In order to get Cumulative value (Column H) for a "selected" EntityId 1,  for Date 28th Oct 2018,  i need the product of last 12 months of (Monthly Return +1) and -1 from it.

Formula in Cumulative LTM = PRODUCT(Monthly Return+1) for last 12 months) -1


I shall be having a dropdown to select the EntityId and Dates. Therefore, these are dynamically changing.

LTM.jpg

776 Views
0 Likes
0 Replies