Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Simplify this Expression

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

5 Replies
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])&')'


talk is cheap, supply exceeds demand
jonathandienst
Partner - Champion III
Partner - Champion III

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....

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Peter_Cammaert
Partner - Champion III
Partner - Champion III

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
Not applicable
Author

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
Not applicable
Author

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.