Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Not applicable

Progressive Month

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.

Tags (1)
7 Replies
Highlighted
Valued Contributor III

Re: Progressive Month

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.

Highlighted
Not applicable

Re: Progressive Month

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.progressive2.jpg

Thanks you.

Highlighted
Not applicable

Re: Progressive Month

hello see my explample. i think that is ok.

Highlighted
MVP
MVP

Re: Progressive Month

Maybe like

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

as expression in the previously attached sample?

Highlighted
Not applicable

Re: Progressive Month

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

]
;

Highlighted
Not applicable

Re: Progressive Month

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

Do you want "paste" the code here?

Thanks.

Highlighted
Not applicable

Re: Progressive Month

in your script put

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