topic Measure calculated as a progressive in QlikView

Measure calculated as a progressive

Mon, 18 Apr 2011 10:41:05 GMT

Hi,

I need to calculate a measure as a progressive from january to a selected month. I load a table with year and month as dimensions and an amount as a measure. For year and month selected I want to show the sum of monthly amount from january of the year selected to the month selected. I don't want to show this sum as a partial sum in the chart. The mechanism is similar to a year to date calculation.

Any suggests to me, please. Thanks

Measure calculated as a progressive

Mon, 18 Apr 2011 10:46:35 GMT

Try

sum({$<Year = {$(=only(Year))}, Month = {"<=$(=max(Month))"}>} Amount)

Regards

Anders

Measure calculated as a progressive

Mon, 18 Apr 2011 11:13:49 GMT

Hi,

I have replaced your expression to sum(Amount) in my pivot chart but I haven't the result desired.

In my table I have:

- Year = 2011, Month = 1, Amount = 500

- Year = 2011, Month = 2, Amount = 600

- Year = 2011, Month = 3, Amount = 1000

I want to show 2100 when I select year = 2011 and month = 3.

Thanks

Measure calculated as a progressive

Mon, 18 Apr 2011 11:29:30 GMT

I have attach an example.

Regards

anders

Measure calculated as a progressive

Tue, 19 Apr 2011 07:59:52 GMT

Oh, thanks, but I have applied your sample that it doesn't function for my document. In my pivot chart I have another dimension before Year and Month, fe Person Name. In this case, do I change your set analysis expression? For each person it must be calculated the progressive amount with the fixed selected year and month between january and the selected month.

However, your sample is a bit different from what I'd like to do. I don't want the progressive amount with the compressed year or, in other terms, when I expand the year I'd like to show for january the amount equals to 500, for february 1100 (500 + 600) and for march 2100 (500 + 600 + 1000). For a selected month I must show the progressive amount from january to the selected month.

Thanks

Measure calculated as a progressive

Tue, 19 Apr 2011 09:42:59 GMT

I have attach a new example

Regards

Anders