Simplify this Expression

[Anonymous]

Hi All,

I am having a Pivot table which has the "LINK"  for another qvw (B.QVW) So in my orginal qvw my expression goes like below

=if(len[Instrument No] > 0, 'Chart'&'<URL>'&(B.QVW_URL)&'select=LB105,('&[Instrument No]&')')

Here due to huge number of Instrument details I am getting "Out of Object Memory" issue in Accesspoint.

With this also having few other expressions as well. So I would like to know how to simplify this expression.

-Jay

[Gysbert_Wassenaar]

Is B.QVW_URL a field? Or a constant? Perhaps you can use a variable for it: vB_URL: 'http://B/MyDoc.qvw'

='Chart<URL>'& $(vB_URL) &'select=LB105,('& Only({<[Instrument No]={'>0'}>}[Instrument No])&')'

[jonathandienst]

Doesn't there need to be a separator (probably a ?) between the URL and the "select" parameter?

ie Not:      "http://B/MyDoc.qvwselect=....."

but           "http://B/MyDoc.qvw?select=....."

='Chart<URL>'& $(vB_URL) &'?select=L....

[Peter_Cammaert]

As a calculated dimension this will probably work. As a real expression, this will only work if the evaluation of each field ([Instrument No] and B.QVW_URL) leads to only one distinct value.

If [Instrument No] is a dimension in your table, a calculated dimension may be the simpler choice.

Peter

[Anonymous]

Hi Gysbert Wassenaar ,

I have tried with using URLs in variable and still I am not getting any luck with this expression.

So is there is any other possibilities to reduce this issue.

[Anonymous]

Hi Peter Cammaert,

Thank you for your reply. My requirement is it shuld be as a expression so that users can able to see the urls under different category.