Re: Rolling grayed out - Qlik Community

qlikviewaf · ‎2017-12-21

Anyone knows why the Rolling is grayed out?

How i can solve this?

Anil_Babu_Samineni · ‎2017-12-21

"Accumulation" section won't visible for Pivot Table..

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

qlikviewaf · ‎2017-12-21

Which could be a solution ?

Anil_Babu_Samineni · ‎2017-12-21

To overcome in Pivot table? you need to write expression?

RangeSum(Above(TOTAL Your Measure, 1, RowNo()))

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

qlikviewaf · ‎2017-12-21

I would like to have the sum of last 12 month based on the maximum "Invoice_date" done on the selection.

How this can be build?

This is the formula for sales based on the selection (imagine May - 2017)

=Sum(ExtendedUSD)

Which shuold be the formula to retrieve the last 12 month sales ?

Thanks for clarifing!