3 Replies Latest reply: Dec 14, 2011 7:57 AM by Stefan Wühl RSS

    top 5 shipments that are ontime

    Aissam Boumejjane

      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