Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Partner
Partner

ratio in rolling 12 seta nalysis

Hi all,

I need to  make a ratio in a rolling12 seta nalysis between first value of the range (newer) and the last one (older)

Any idea to do that?

Many Thanks for your help

Bruno

Sum

({Real*$(vMeasure)* $<MonthID =  {">=$(=Max(MonthID) - 11)<=$(=Max(MonthID))"},
Date = {
"<=$(=Max(Date))"},
Year =,
Quarter = ,
Period = ,
[Period (#)] = ,
Month =
>}QTD)/

Above(

Sum

({Real*

$(vMeasure)* $<MonthID =  {">=$(=Max(MonthID) - 11)<=$(=Max(MonthID))"},
Date = {
"<=$(=Max(Date))"},
Year = ,
Quarter = ,
Period = ,
[Period (#)] = ,
Month =
>}QTD))

1 Reply
Partner
Partner

I found solution.

This is the best way?

Thanks

Bruno

=Sum
({Real*$(vMeasure)* $<MonthID =  {">=$(=Max(MonthID) - 11)<=$(=Max(MonthID))"},
Date = {
"<=$(=Max(Date))"},
Year =,
Quarter = ,
Period = ,
[Period (#)] = ,
Month =
>}QTD)/

/Sum({Real*$(vMeasure)* $<MonthID =  {"$(=min({Real*$(vMeasure)* $<MonthID =  {">=$(=Max(MonthID) - 11)<=$(=Max(MonthID))"},
Date = ,
Year =,
Quarter = ,
Period = ,
[Period (#)] = ,
Month =
>}MonthID))"
},
Date = {
"<=$(=Max(Date))"},
Year =,
Quarter = ,
Period = ,
[Period (#)] = ,
Month =
>}QTD)