Discussion Board for collaboration on QlikView Scripting.
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.
Go to Solution.
Try an expression in your line chart like
=Sum( Aggr( If(Rank(Sum( Value)) <=3, Sum(Value)), Month, Customer))
edit: changed Aggr() dimension order.
Can you please attach your qvw file?
May be this:
Expression: =Sum(Aggr(If(Rank(Value, 0, 1) <= 3, Value), Month, Customer))