Populating two fields on drilldown dashboard from one click.value

[pirateplunder]

Hi

I have a table on a dashboard who's click.value is two numeric params joined like this:

NumA_NumB

I have a second dashboard that I want to drill down to from that table that has form inputs for NumA and NumB. 

Is there any way i can split the click.value and use it to populate the two form fields from the drilldown? I've tried using mvindex(split($click.value$,"_"),0) but it doesn't work. I can populate both the form fields with NumA_NumB but just can't work out how to split it. 

[pirateplunder]

Thats great and worked a treat...

<drilldown>
  <eval token="numA">mvindex(split($click.value$,"_"),0)</eval>
  <eval token="numB">mvindex(split($click.value$,"_"),1)</eval>
  <link target="_blank">....?form.NumA=$numA$&amp;form.NumB=$numB$</link>
</drilldown>

[richgalloway · Accepted solution]

That mvindex call should work in an <eval> element within <drilldown>.

You also can use it in the destination search, but will have to use a named token rather than $click.value$.