topic Re: Return Last 5 Rows Matching Selection in QlikView

Return Last 5 Rows Matching Selection

c_latham — Sat, 16 Nov 2024 04:59:33 GMT

Hi All,

I have a basic set of data whereby I am looking at vehicle turn around time.

I need to compare the 'NAME' field where selected and display the previous 5 'TurnAround' times for that selection.

Data looks like:

ID NAME VALUE YEAR TurnAround

001	AA12 ABC	YES	2014	21.5
002	AA12 ABC	YES	2014	18.7
003	AA12 ABC	NO	2014	20.1
004	BB10 AAY	NO	2015	34.3
005	CA11 MEE	NO	2015	18.1
006	BB08 KKH	NO	2015	19.5

If I select 'AA12 ABC' I want to display: '21.5, 18.7, 20.1'

Can this be achieved with Set Analysis?

Re: Return Last 5 Rows Matching Selection

dplr-rn — Tue, 11 Dec 2018 17:31:56 GMT

Please explain further.
i dont understand the challenge going by what you mention.
if you create a table like above and the name is selected the table will get filtered by that name.

@c_latham wrote:

If I select 'AA12 ABC' I want to display: '21.5, 18.7, 20.1' -- How do you want to display this?

Re: Return Last 5 Rows Matching Selection

prieper — Wed, 12 Dec 2018 14:43:07 GMT

If you need to display in a textbox, give it a try with

CONCAT(DISTINCT Turnaround, ', ')

This should deliver all possible Turnaround-entries for the current selection, separated by a comma (and - in case of multiple entries - give each value only once)

HTH Peter