Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

String replacement with variable

Hi,

How is it possible that I have some results with :

Sum({<NOM_PERIODE={'20160412-0025-24 chauffe'}>}VALEUR_METRIQUE))

but when I put the string '20160412-0025-24 chauffe' in a variable SELECTION I don't have any result with :

Sum({<NOM_PERIODE={$(SELECTION)}>}VALEUR_METRIQUE))

Am I missing something ?

4 Replies

Re: String replacement with variable

May be try this:

Sum({<NOM_PERIODE={$(=SELECTION)}>} VALEUR_METRIQUE)

Re: String replacement with variable

Are you specifying 20160412-0025-24 chauffe (Without single quotes) or '20160412-0025-24 chauffe' (with single quotes) as your variable definition?

If it is without, may be you need this:

Sum({<NOM_PERIODE={$(=Chr(39) & SELECTION & Chr(39))}>} VALEUR_METRIQUE)

MVP
MVP

Re: String replacement with variable

Or

Sum({<NOM_PERIODE={'$(SELECTION)'}>} VALEUR_METRIQUE)

Not applicable

Re: String replacement with variable

It worked with

Sum({<PERIODE_NOM={'$(=vREFERENCE_NOM)'}>}METRIQUE_VALEUR)