Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
paulosilva
Contributor II
Contributor II

Function that works same AGO on obiee

Hi, i need a function that works finding values on a range date, type a one year ago and sum the values. 

 

AGO("FACT"."VALUE", "MONTH"."YEAR", 1)

 

 

Labels (4)
1 Solution

Accepted Solutions
thi_pham
Creator III
Creator III

sum({<[Date.autoCalendar.YearsAgo]={1}>} VALUE).

It will depend on where you intend to use this statement, but generally it is something like that.

View solution in original post

2 Replies
thi_pham
Creator III
Creator III

sum({<[Date.autoCalendar.YearsAgo]={1}>} VALUE).

It will depend on where you intend to use this statement, but generally it is something like that.

View solution in original post

paulosilva
Contributor II
Contributor II
Author

tks its works !