Displaying value by specific row number

Fri, 16 Aug 2013 12:23:25 GMT

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

Re: Displaying value by specific row number

cesaraccardi — Fri, 16 Aug 2013 12:44:53 GMT

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

topic Displaying value by specific row number in QlikView

Displaying value by specific row number

Re: Displaying value by specific row number