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.
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$.
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$&form.NumB=$numB$</link>
</drilldown>
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$.