I'm trying to create a bar chart where I have the top 5 shipments that are ontime.
I've used Ctry (Country) as my Dimension
"if(Aggr(rank(Count(Order)),Ctry, Status)<=5, count(Order)) / Count(total Order)" as my expression. I think that there is something wrong with my expression, as I'm not getting the right results. I've looked at the sort tab, it's sorted desending by Y-value.
I've attached a qlikview sample. hope some one can help me out.