Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
qlikviewaf
Creator
Creator
‎2017-12-21 10:53 AM

Rolling grayed out

Anyone knows why the Rolling is grayed out?

How i can solve this?

ROLLING 12 M.png

Labels (1)
Labels
885 Views
0 Likes
4 Replies
Anil_Babu_Samineni
MVP
MVP
‎2017-12-21 10:55 AM

"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
802 Views
0 Likes
qlikviewaf
Creator
Creator
‎2017-12-21 10:57 AM
Author

In response to Anil_Babu_Samineni

Which could be a solution ?

802 Views
0 Likes
Anil_Babu_Samineni
MVP
MVP
‎2017-12-21 11:00 AM

In response to qlikviewaf

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
802 Views
0 Likes
qlikviewaf
Creator
Creator
‎2017-12-21 11:06 AM
Author

In response to Anil_Babu_Samineni

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!

802 Views
0 Likes