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


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