Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Working with cumulative for Pareto

My data is has following cols

Country, State, Period(in mm/dd/yyyy format), Qty, Year

A, A1, 1/1/2015, 10, 2015

A, A2, 1/1/2015, 20, 2015

A, A1, 2/1/2015, 25, 2015

A, A1, 1/1/2014, 15, 2014

A, A1, 2/1/2014, 10, 2014

B, B1, 3/1/2015, 30, 2015

I want to achieve the following output

Year     Country     Sum(Qty) (for the Year) (in descending order)     Cum Qty          Cumulative % (at  Year level)

2015                   A           10+20+25=55                                          55                  =55/(55+30)

2015                   B            30                                                         55+30=85        =85/(55+30)

2014                   A            15+10=25                                               25                 =25/(25)

Any help much appreciated.

Currently I achieve the above checking the Relative and Full Accumulation options.

1 Reply
MVP
MVP

Re: Working with cumulative for Pareto

Here is a different approach.

Create a straight table with dimensions Year and Country and first Expression

=Sum(Qty)

Sort your table first by Year desc, then by Sum(Qty) desc.

Add two  expressions:

=rangesum(above(sum(Qty),0,rowno()))

=column(2) / Sum(Total<Year> Qty)

Community Browser