rolling 3 o 3 for max Month Data

[Anonymous]

I need to find  (recent 3 months - previous 3months of recent)/ previous recent 3 months.

When I select Dec below are the results calculated for data present in the latest month. But Requirement is if it is Nov latest, If data is not present for month I selected;even if I select December, How can I show its rolling 3 o 3 for latest data like below(NOV, Oct, Sept) for corresponding

for adding 3 months

sum( {<[Calendar Month Age]={"<=$(=min([Calendar Month Age])+2)>=$(=min([Calendar Month Age]))"},[Calendar Month Name],[Calendar Year]

        >} [ Volume])

[Gysbert_Wassenaar]

Perhaps this document helps: Calculating rolling n-period totals, averages or other aggregations

[Anonymous]

I understand different ways to get Rolling math's. But in all examples we have Max date as common for data. I have different  Maximum end dates for countries. For Example US - Max date 04/01/2015, UK - Max date 03/01/2015(MM/DD/YYYY) and so on about 20 Coutries.... I can extract max dates by Group by.

but , How can I show 3 over 3  for UK still as March when user selects April Month because UK has March as Maximum(which is blank-).Some thing like I need to differ a variable from cell to cell for Maximum date in straight table in same expression?

[Gysbert_Wassenaar]

Can you post a qlikview document that explains the problem with some example data?

Preparing examples for Upload - Reduction and Data Scrambling

[Anonymous]

please find attachment .

I need to show latest  3 o3  months data when data is not available. you can see when latest date is selected, Jan 2015.for France,UK and US need to show their latest 3o3 ; even selection does not fall.

if data available fine, otherwise latest 3o3, not '0' to show.

[Gysbert_Wassenaar]

I need to show latest  3 o3  months data when data is not available.

I don't understand. How is it possible to show data when it is not available?

[Anonymous]

attached here actual fact and dimension table.