Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikviewaf
Creator
Creator

Rolling grayed out

Anyone knows why the Rolling is grayed out?

How i can solve this?

ROLLING 12 M.png

4 Replies
Anil_Babu_Samineni

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
qlikviewaf
Creator
Creator
Author

Which could be a solution ?

Anil_Babu_Samineni

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

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
qlikviewaf
Creator
Creator
Author

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!