Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
What is PCR? A field? A variable?
I URL an expression, a dimension?
PCR is a Field
URL is an Expression
Please let me know if you need anymore Information
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.
Thanks for your reply adrian..
But could you explain it a little further??
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...