topic Re: Retrieving the nth selection in QlikView

Retrieving the nth selection

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Retrieving the nth selection

Thu, 22 Jun 2017 09:30:03 GMT

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?

Re: Retrieving the nth selection

henrikalmen — Thu, 22 Jun 2017 09:32:49 GMT

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

Re: Retrieving the nth selection

henrikalmen — Thu, 22 Jun 2017 09:41:10 GMT

Would this text box expression give you what you want?

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

Re: Retrieving the nth selection

Thu, 22 Jun 2017 09:49:16 GMT

That's it! Thank you