Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Expression problem (sum if replace)

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

0 Replies