problem with accumulate by month - Qlik Community

Report Inappropriate Content · ‎2013-04-18

Hello Experts,

I need a help to resolve this problem

I have in Input in a pivot table

Applications Servers Months

A01 S1 Octobre-2012

A11 S1 Octobre-2012

A02 S2 November-2012

A03 S4 December-2012

A04 S2 January-2013

A14 S1 January-2013

A03 S1 February-2013

A01 S2 March-2013

I have to accumulate a number of distinct “applications” by month with a condition that is not accumulate “applications” if exist in previous month.

The expression I’m using is

RangeSum(Above(Count (distinct([Applications])),0,RowNo()))

Result provided

Months Cumulated different Numbers Of Applications by month

Octobre-2012 2

November-2012 3

December-2012 4

January-2013 6

February-2013 7 (a problem for me because A03 exist in December-2012)

March-2013 8 (a problem for me because A03 exist in October-2012)

And I want to have this result

Months Cumulated different Numbers Of Applications by month

Octobre-2012 2

November-2012 3

December-2012 4

January-2013 6

February-2013 6 (because A03 exist in December-2012)

March-2013 6 (because A01 exist in Octobre-2012)

Thank you in advance for tour help.

Anonymous · ‎2013-04-18

I am working on this exact same issue. Anybody have an idea on this?

I am counting distinct values over time but in the accumulation it is not discounting the distinct values from the previous months in the selection.

Report Inappropriate Content · ‎2013-04-19

Hi Aaron,

I found a formula to count the values do not included in the previous month:

if (count(Period_MonthName)>1, MinString(Period_MonthName),Period_MonthName)

But I don't know how to transform this expresion to dimension! Do you have an idea?

Best regards.