top 5 shipments that are ontime

[Anonymous]

Hi Guys,

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

and

"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.

Thanks in advance!

iSam

[swuehl · Accepted solution]

Hi iSam,

maybe like attached? Check out the sort order expression:

=rank(count({<Status={OnTime}>}Order))

Hope this helps,

Stefan

[Anonymous]

Many thanks Stefan!!! That indeed did the job!

iSam

[swuehl]

I think you can also simplify your expression then to count(Order) / count(total Order), I forgot to change this in my sample above.