Expression problem (sum if replace)

Mon, 09 Jul 2012 11:07:04 GMT

Hi, can anaone help me with this problem? For this sample I simplified the expression.

In a text object I need to replace some text like this:

=sum(if(replace('str1_dim1 > 100', 'str1', 'val1'), budget))

Q: what is wrong about this? How can I force the string-replacement?

Note:

Original this would be something like:

vTmp = 'str1_dim1 > 100'

=sum(if(replace($(vTmp), 'str1', 'val1'), budget))

Regards,

Coen

topic Expression problem (sum if replace) in QlikView