topic Re: Calculate quarter from summarized data in QlikView

Calculate quarter from summarized data

Thu, 07 Apr 2016 14:08:13 GMT

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:

How do i load the qvd's i want to use automatically to my model?
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

Re: Calculate quarter from summarized data

Gysbert_Wassenaar — Thu, 07 Apr 2016 14:32:21 GMT

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

Re: Calculate quarter from summarized data

Fri, 08 Apr 2016 09:07:08 GMT

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

Re: Calculate quarter from summarized data

Gysbert_Wassenaar — Fri, 08 Apr 2016 09:13:28 GMT

Post a small qlikview document that demonstrates the problem.

Re: Calculate quarter from summarized data

Fri, 08 Apr 2016 13:08:26 GMT

Hi,

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

Re: Calculate quarter from summarized data

Fri, 08 Apr 2016 13:29:47 GMT

gwassenaar‌ its now attached

Re: Calculate quarter from summarized data

Gysbert_Wassenaar — Fri, 08 Apr 2016 14:56:29 GMT

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

Re: Calculate quarter from summarized data

Sat, 09 Apr 2016 10:31:44 GMT

the qvd is quite huge, hence I couldnt post it

Re: Calculate quarter from summarized data

Gysbert_Wassenaar — Sun, 10 Apr 2016 15:04:21 GMT

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