Link Problem in Pivot Table

[#1]

Hi,

I am trying to provide a Hyperlink in Pivot table.

I am using the following Expression:

PCR & '<URL>' & 'http://someurl?CR_Number=' & PCR

According to this expression suppose PCR = 141 then it will direct me to the following URL:

http://someurl?CR_Number=141

Now, the problem is that PCR may have multiple values which separated by ','

For Example PCR = 245,246

Ideally If I click on 245...it should direct me to the following URL:

http://someurl?CR_Number=245

an If I click on 246...it should direct me to the following URL:

http://someurl?CR_Number=246

but at the moment if I click on either of the two numbers it is directing me to the following URL:

http://someurl?CR_Number=245,246 (This URL does not exist)

NOTE: We may have more than two numbers.

Kindly help me out yo adress this problem.

Thanks & Regards

Rohit

[Anonymous]

What is PCR? A field? A variable?

I URL an expression, a dimension?

[#3]

PCR is a Field

URL is an Expression

Please let me know if you need anymore Information

[Anonymous]

for URL try to use a variable (v_PCR) instead of field PCR, and link that variable to the field.But when you don't have anything selected it won't show anything.

[#5]

Thanks for your reply adrian..

But could you explain it a little further??

[Oleg_Troyansky]

I wouldn't say it's about Fields vs. Variables... The problem, as I see it, is because the field PCR can hold multiple values, separated by comma. If you could separate the values in your load script, it would be the best. You can use function subfield() to do it.

If you can't, the only compromise I can see is to always link to the first value, using the same function subfield():

subfield(PCR,1)

Another compromise - you could also have a variable where the user would decide what element to link to , and replace "1" with the variable? Not very elegant, but does the job...