topic Re: rolling 3 o 3 for max Month Data in QlikView

rolling 3 o 3 for max Month Data

Anonymous — Fri, 20 Feb 2015 18:14:39 GMT

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])

Re: rolling 3 o 3 for max Month Data

Gysbert_Wassenaar — Fri, 20 Feb 2015 18:39:32 GMT

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

Re: rolling 3 o 3 for max Month Data

Anonymous — Mon, 04 May 2015 18:36:59 GMT

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?

Re: rolling 3 o 3 for max Month Data

Gysbert_Wassenaar — Tue, 05 May 2015 11:41:08 GMT

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

Preparing examples for Upload - Reduction and Data Scrambling

Re: rolling 3 o 3 for max Month Data

Anonymous — Tue, 05 May 2015 15:56:36 GMT

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.

Re: rolling 3 o 3 for max Month Data

Gysbert_Wassenaar — Tue, 05 May 2015 16:53:23 GMT

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?

Re: rolling 3 o 3 for max Month Data

Anonymous — Tue, 05 May 2015 17:05:21 GMT

attached here actual fact and dimension table.