Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Dynamic text in a text/image object

Dears,

I need to have different text displayed in a Text/Image object depending on a selection:

What I have done so far:

 

Set variables in the loader, IE:

SET v_TXT_EU_15 = 'This is the string for EU 15 blah...';
SET v_TXT_EU_13 = 'This is the string for EU 13 blah...';

In my text object, I set a Measure with a condition:

='Text to display:' & if([Is EU 15]='Yes',v_TXT_EU_15,v_TXT_EU_13))

Which so far, is working...

 

My issue is that the (currently static) text needs to have measures inserted depending on the selection...  and this is something I cannot do in the loader.

What method would you recommend?

PS: I can't use any extention.

 

 

2 Replies
Highlighted
Specialist II
Specialist II

Please share a sample app or data with Expected output
Highlighted
Contributor
Contributor

I can't share the qvf (Not sure what part is confidential or not)

I am currently resorting to create the string in the Measure, it works but it's crass.

 

=if([Is EU 15]='Yes','Text for EU 15:','The EU 13 text:') 
&[Country] 
&' has '
&Count(distinct [%QK_ERC_PI])
&' researchers per million of population which is ' 
&[Num Researchers percentage] 
&' the EU average '
& [Eu research avg] 
&' and ranks ' 
&[Ranking in EU-28]
& ' place.';

This is one sentence out of 60+...