Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

problem with accumulate by month

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.

2 Replies
aaroncouran
Contributor III

Re: problem with accumulate by month

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.

Not applicable

Re: problem with accumulate by month

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.

Community Browser