topic Re: Straightchart presentation conditional Max number in QlikView

Straightchart presentation conditional Max number

Thu, 26 Jul 2012 14:34:42 GMT

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

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

Re: Straightchart presentation conditional Max number

Thu, 26 Jul 2012 14:45:04 GMT

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

Re: Straightchart presentation conditional Max number

Thu, 26 Jul 2012 15:09:00 GMT

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

Re: Straightchart presentation conditional Max number

Thu, 26 Jul 2012 15:09:41 GMT

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

Re: Straightchart presentation conditional Max number

Thu, 26 Jul 2012 15:10:15 GMT

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