topic Re: Progressive Month in QlikView

Progressive Month

Tue, 17 Jul 2012 13:01:30 GMT

I have to create a derived field, which is a progressive on the month, accumulated up to the current month.

Example: Jan -> 1000, Feb -> 200; Mar -> 400; Apr -> 650.

The sequence should be: Jan -> 1000, Feb -> 1200; Mar -> 1600, April -> 2250.

I attach a screen. The field "(progressivo mese)" is what I get.

Solutions?

Thank you.

Re: Progressive Month

nagaiank — Tue, 17 Jul 2012 21:26:05 GMT

In a straight table chart use the following settings:

Dimension: Month

Expression: Sum(Value) and select Full Accumulation in the Accumulation window

This will generate table with cumulative values.

Re: Progressive Month

Wed, 18 Jul 2012 13:17:41 GMT

Thanks a lot.

It's worked.

But i have another question, because the problem is solved only in part.

When i select a month, example Giu, i lost the information accumulated, because the system result only value linked with Giu and not the values linked to Mag+Giu.

Is it possible to resolve this problem?

I load an image that explain this concept.

Thanks you.

Re: Progressive Month

Wed, 18 Jul 2012 14:07:44 GMT

hello see my explample. i think that is ok.

Re: Progressive Month

swuehl — Wed, 18 Jul 2012 14:15:17 GMT

Maybe like

=aggr(rangesum(sum({<mese>}valore),above(sum({<mese>}valore))),mese)

as expression in the previously attached sample?

Re: Progressive Month

Wed, 18 Jul 2012 14:29:10 GMT

from script

tab:

LOAD *,

rangesum(valore,peek('valore',-1)) as valorecum;

LOAD * INLINE [

    mese, valore

    gen, 1

    feb, 2

    mar, 3

    apr, 4

    mag, 5

    june, 6

    lu, 7

    ag, 8

    set, 9

    ott, 10

    nov, 11

    dic, 12

];

Re: Progressive Month

Wed, 18 Jul 2012 14:48:24 GMT

Unfortunately, i have a Personal Edition and i can't open the document.

Do you want "paste" the code here?

Thanks.

Re: Progressive Month

Wed, 18 Jul 2012 19:00:12 GMT

in your script put

rangesum(PROG,peek(PROG,-1)) as PROG;