Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

accumulate issue 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 your help

2 Replies
Not applicable

Re: accumulate issue by month

résolu

kumarnatarajan
Valued Contributor

Re: accumulate issue by month

Hi,

Find the attached file.

Community Browser