Can this expression be optimized?

[#1]

Hi,

I have an expression : =Avg({$<Institution={'$(=concat(Institution2,chr(39)&','&chr(39)))'}>} [Actual value]) which works perfectly BUT seems to slow down my Qlikview app. quite a bit. - I get an hourglass for a few seconds on the radar chart that this expression is being used on.

It could be a long shot, but there could be a more efficient approach??

Thanks!

[swuehl · Accepted solution]

Hi beanz,

try using

=Avg({$<Institution= p(Institution2) >} [Actual value])

Regards,

Stefan