Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Retrieving the nth selection

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 

1 Solution

Accepted Solutions
Highlighted
Creator
Creator

Would this text box expression give you what you want?

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

View solution in original post

4 Replies
Highlighted
Not applicable

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?

Highlighted
Creator
Creator

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"?

Highlighted
Creator
Creator

Would this text box expression give you what you want?

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

View solution in original post

Highlighted
Not applicable

That's it! Thank you