# New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

## Straightchart presentation conditional Max number

Hi Experts,

I have a straight chart that has [Task] as demension and as experessions has [Number of tasks] , [Rank by number ], [Time to complete], [Ranked by time to complete].

There are a shedload of tasks, I have them sorted by [Ranked by time to complete]. I wish to only show the top 5 of Number.

So using the below sample data = It would show all tasks as far as Pinch as thats the last task in the Top 5.

Is that possible

Thanks

A

 Number Rank # Task Time Rank Time 70 5 Eat 100 1 80 3 Drink 90 2 55 6 Be Merry 80 3 90 2 Dance 50 4 15 7 Fight 40 5 100 1 Clean up 30 6 77 4 Pinch 25 7 2 9 Cook 20 8 10 8 Tidy 15 9
4 Replies
Not applicable

## Re: Straightchart presentation conditional Max number

Actually now I think about it , its probably how I write the expressions

so sum Number only if Rank time is greater than 5

=sum(if(rank(sum(Number)*CycleTime/60)>5,Number))

I've tried the above - it doesnt work - any suggestions greatly appreciated

Thanks

A

Not applicable

## Re: Straightchart presentation conditional Max number

haha Me again

if(rank(sum(Number)*CycleTime/60)<6 or rank(sum({1}Number))<6,sum(Number),null())

The above works as in it will only sum when it is ranked in the Top 6 in either Rankings

But now is there a way to hide the row if the value is Null in the Sum Number column?

Thanks
A

Not applicable

## Re: Straightchart presentation conditional Max number

haha Me again

if(rank(sum(Number)*CycleTime/60)<6 or rank(sum({1}Number))<6,sum(Number),null())

The above works as in it will only sum when it is ranked in the Top 6 in either Rankings

But now is there a way to hide the row if the value is Null in the Sum Number column?

Thanks
A

Not applicable

## Re: Straightchart presentation conditional Max number

haha Me again

if(rank(sum(Number)*CycleTime/60)<6 or rank(sum({1}Number))<6,sum(Number),null())

The above works as in it will only sum when it is ranked in the Top 6 in either Rankings

But now is there a way to hide the row if the value is Null in the Sum Number column?

Thanks
A