Discussion Board for collaboration related to QlikView App Development.
I am failing at building the TOP3-dimension with the formula
=If(Rank(Sum(TOP3-Category)) <=3, Sum(TOP3-Category))
as it would take ages to process all values. The plan is a table like this here:
Thanks in advance! Best regards.
create a straight table or pivot chart with two dimension
2.=aggr(if(rank(sum(sales))<=3,[Category]),[Customer],[Category]) (make sure field names are correct)
add your measure(sum(sales) for example)
View solution in original post
put the second calculated dimension as
attaching qvw, i used your data set and showed top 2 out of it, look at the top 2 pivot in qvw