set analysis help, i think

Anonymous — Thu, 21 Mar 2019 21:23:53 GMT

Good Afternoon;

I hope this is the right forum, I inherited a dashboard i am trying to understand, its source comes from a spreadsheet.

sum ( {$<[Ops Year] = {$(#=Only(_YYYY))}, [Ops Month] = {"<=$(#=Only(_MM))"},[Division]={'A','B','C','D','E','F','G'}>} [Bookings]/1000000)
/
sum ( {$<[Ops Year] = {$(#=Only(_YYYY))}, [Ops Month] = {"<=$(#=Only(_MM))"},[Division]={'A','B','C','D','E','F','G'}>} [Revenue-Actual]/1000000)

Th calculation works however what i need to change is that instead of the values from one month i need the sum of all months[Ops Months]. This would only be for the denominator.

the number for January I am getting is .19 which is correct as it is only one month, however for February i need the number to roll both January and February numbers in revenue.

Based on the selection of the [Ops month] is should calculate the revenue amount for everything less than or equal to for that selection for the divisions stated, any ideas? I have attached a sample of the source data for the calculation

Re: set analysis help, i think

Claudiu_Anghelescu — Sun, 24 Mar 2019 15:45:43 GMT

sum ( {$<[Ops Year] = {$(#=Only(_YYYY))}, [Ops Month] = {*},[Division]={'A','B','C','D','E','F','G'}>} [Bookings]/1000000)
/
sum ( {$<[Ops Year] = {$(#=Only(_YYYY))}, [Ops Month] = {*},[Division]={'A','B','C','D','E','F','G'}>} [Revenue-Actual]/1000000)

topic set analysis help, i think in QlikView

set analysis help, i think

Re: set analysis help, i think