Displaying value by specific row number

[#1]

Hello, im new to qilkview and appreciate all the help I can get 🙂

Im trying to display an arrival time in a piviot table for each customer ID. Some of them have multiple times and thats why I need to specify which one i want to display by choising the row number. The first and the last time can be shown by using min and max but how do i display the times inbetween those?

LOAD * INLINE [

    ID, Time

    32-588, 17:00

    32-588, 18:00

    32-588, 19:00

    32-588, 20:00

    32-589, 09:00

    32-589, 10:00

    32-589, 11:00

];

ID	1st time	2nd time	3rd time	last time
32-588	=min(time)	row number 2 in timetable	row number 3 in timetable	=max(time)
32-589

[cesaraccardi · Accepted solution]

Hi,

There is an additional parameter rank for the aggregation functions min and max that you could use.

Extracted from QlikView help:

min([{set_expression}][ distinct ] [ total [<fld {, fld}>]] expression [, rank]))

Returns the numeric minimum value of expression or field iterated over the chart dimension(s). Rank defaults to 1 which corresponds to the lowest value. By specifying rank as 2 the second lowest value will be returned. If rank is 3 the third lowest value will be returned and so on.

Examples:

min( Sales, 2 )

Regards,

Cesar