Calculate quarter from summarized data

[#1]

Good day,

I'm working with a year load of data (qvd's), loaded monthly.

The data is summarized quarterly, in this manner;

for any quarter, the data is always summarized to the last month of the 'selected' quarter.

For instance, calculations for Q1 (Jan, Feb, March) must only be based on month of March qvd, since it contains data for Jan, Feb and March.

The same applies for Q2, calculations must be based on June data,

Q3 = Sept

Q4= Dec

Questions:

1. How do i load the qvd's i want to use automatically to my model?
2. Since I have a list box that has YEAR, QUARTER, MONTH (see below pic); when I click on the quarter the calculations must be based on the logic I explained above.

Your assistance will be highly appreciated,

Kind regards,

Mbini

[Gysbert_Wassenaar]

Then associate only Dec with Q4 and only Sep with Q3 and only Jun with Q2 and only Mar with Q1. You can do this with in the load script with for example this: Pick(Match(Month,'Mar','Jun','Sep','Dec'), 'Q1', 'Q2', 'Q3','Q4') as Quarter

[#3]

Hi,

I have tried it its not working, on my app I have subroutine that checks on the 'Date' as its the field I use to connect my data with

[Gysbert_Wassenaar]

Post a small qlikview document that demonstrates the problem.

[#5]

Hi,

I have been try to attach the app, but i'm not getting an option to

[#6]

gwassenaar‌ its now attached

[Gysbert_Wassenaar]

Can you explain how that document is supposed to explain anything? It doesn't contain any data.

[#8]

the qvd is quite huge, hence I couldnt post it

[Gysbert_Wassenaar]

Perhaps this document helps: Preparing examples for Upload - Reduction and Data Scrambling