Retrieving the nth selection

[#1]

Hi folks,

Please help me. I am floundering and clearly barking up the wrong tree.

In my attached qvw file I have a chart that plots vertical lines whenever there is an event.

It's too much information for me to display the details of each event on the chart, so I would like the user to be able to select the nth result and have it highlighted on the chart with the details appearing in a text box. .

I can't use popup labels because this chart will be going underneath another chart, which is in an alternate state.

I don't have the space to have a table with a list of selected event dates and details (I don't think I do anyway)

I've experimented with the RowNo() and Rank functions, but I think these are both inappropriate.

Any ideas? It doesn't have to be the user selecting 'n', just a way of allowing them to select which event they want to see the details for within the current selection (in the real application is obviously more complicated than simply selecting Date!)

Thanks in advance. Any help appreciated

Karen 

[#2]

Ah! I have figured out the chart syntax.

The rank function was correct after all!

See attached.

I just need to figure out the syntax on the text box now.

Anyone?

[henrikalmen]

What details do you want shown in the text box? If varEvno = 3, what should the text be? For the saved selection, is it "On this day the 6th, I ate 0 oranges"?

[henrikalmen · Accepted solution]

Would this text box expression give you what you want?

=subfield(concat(Details, ';', Date), ';', varEvno)

[#5]

That's it! Thank you