Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
apoitevin
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
techvarun
Specialist II
Specialist II

Please share a sample app or data with Expected output
apoitevin
Contributor
Contributor
Author

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+...