Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

aboumejjane
Contributor

top 5 shipments that are ontime

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

1 Solution

Accepted Solutions
MVP
MVP

Re: top 5 shipments that are ontime

Hi iSam,

maybe like attached? Check out the sort order expression:

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

Hope this helps,

Stefan

3 Replies
MVP
MVP

Re: top 5 shipments that are ontime

Hi iSam,

maybe like attached? Check out the sort order expression:

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

Hope this helps,

Stefan

aboumejjane
Contributor

Re: top 5 shipments that are ontime

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

iSam

MVP
MVP

top 5 shipments that are ontime

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

Community Browser