topic Re: Simplify this Expression in QlikView

Simplify this Expression

Anonymous — Tue, 26 Jan 2016 09:59:00 GMT

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

Re: Simplify this Expression

Gysbert_Wassenaar — Tue, 26 Jan 2016 11:44:33 GMT

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

Re: Simplify this Expression

jonathandienst — Tue, 26 Jan 2016 11:53:51 GMT

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

Re: Simplify this Expression

Peter_Cammaert — Tue, 26 Jan 2016 12:57:32 GMT

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

Re: Simplify this Expression

Anonymous — Wed, 27 Jan 2016 07:51:47 GMT

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.

Re: Simplify this Expression

Anonymous — Wed, 27 Jan 2016 07:53:06 GMT

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.