topic Re: Top 3 Chart - Aggr + Rank + Set Analysis in QlikView

Top 3 Chart - Aggr + Rank + Set Analysis

Fri, 23 Oct 2015 15:38:29 GMT

Gents,

I'm struggling in create a new line chart with my "top 3" ranking data.

My goal is figure out the top "3" customers for each period and plot in a chart, as the picture below.

I think I'm closer to the solution using Aggr+Rank, but my results does not match yet. Any clue in the final expression?

Thanks in advance.

miguelbraga — Fri, 23 Oct 2015 15:44:11 GMT

Hi Fabio,

Can you please attach your qvw file?

Thanks,

swuehl — Fri, 23 Oct 2015 15:44:29 GMT

Try an expression in your line chart like

=Sum( Aggr( If(Rank(Sum( Value)) <=3, Sum(Value)), Month, Customer))

edit: changed Aggr() dimension order.

sunny_talwar — Fri, 23 Oct 2015 15:53:44 GMT

May be this:

Expression: =Sum(Aggr(If(Rank(Value, 0, 1) <= 3, Value), Month, Customer))