Expression show certain value based on filter pane sorting

[Jonasilsoe]

Hi

I have two columns. Column A is the Identification number (ID 1,2,3 ... 10) and the second column B is a description of the ID. The column is called: 'Header'.

In the qliksense app I have a three sheets with 1) filterpane sorting on ID's and a Text & image chart.

What I need is an expression which allow me to fx click/filter on three ID's where each of my three sheets should show the 'Header' description on only one ID and not the same.

fx. When the filter pane is sorted on ID 1, ID 2 and ID 3 what I need is:

Sheet 1 needs to show: ID 1 = My Text & Image chart should only lookup the 'Header' for ID 1

Sheet 2 needs to show: ID 2 = My Text & Image chart should only lookup the 'Header' for ID 2

Sheet 3 needs to show: ID 3 = My Text & Image chart should only lookup the 'Header' for ID 3

[Vegar]

Maybe something like this:

Only({<ID={$(=MAX(ID, 1 ))}>}Header)

Only({<ID={$(=MAX(ID, 2 ))}>}Header)

Only({<ID={$(=MAX(ID, 3 ))}>}Header)

[Jonasilsoe]

Thank you for the answer. Unfortunately it doesn't work.

Also it should somehow loop down i.e. if ID 54, 87 and 100 is chosen. 

So the first sheet has to show the lowest ID number, the next sheet has to show the second lowest number and so on.