Cumulative data Expression?

Tue, 24 Sep 2013 02:29:37 GMT

Dear all,

I want to ask how to get the syntax of the data cumulative GPW in each year 2012 and 2013 below?

illustrative example of a data:

-July 2012 GPW 10 million

-August 2012 GPW 10 million

-December 2012 GPW 5 million

-January 2013 GPW -10 million

-February 2013 GPW 15 million

Filter the data when in the month of JANUARY

2012 = 0

2013 = 15 MILLION

Filter the data when in the month of OCTOBER

2012 = 20 MILLION

2013 = 30 MILLION

Filter the data when in the month of DECEMBER

2012 = 25 MILLION

2013 = 30 MILLION

Tq before.

Re: Cumulative data Expression?

Tue, 24 Sep 2013 08:35:36 GMT

Hi,

I have three fields in my data model: TIME_KEY, MONTH and YEAR. The three are numeric.

The higher the TIME_KEY, the more advanced in the time. In other words, the TIME_KEY X+1 is always after the TIME_KEY x.

I assumed the user only can choose one TIME_KEY :

Your expression =sum({<MONTH=, YEAR=, TIME_KEY={"<=$(TIME_KEY)"}> } VALUE)

You may also create a variable, for example:

vTime_Key = TIME_KEY

and sum({<MONTH=, YEAR=, TIME_KEY={"<=$(vTime_Key"}> } VALUE)

If you want to get a cumulative into your chart (or report) while using one of the three dimensions, you will have to use other methods: cumulative or rangesum/above functions .... or modify your data model to "store" the way to compute the cumulative you want.

Fabrice

topic Cumulative data Expression? in QlikView

Cumulative data Expression?

Re: Cumulative data Expression?