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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2016-12-29 02:36 AM

Dynamic Text

Hi,

I am trying to create a text with dynamic figures...

eg. The total road accidents has increased / decreased by 15% YOY. The market has shown a 12% increase /decrease.

The red texts are dynamic in nature and are dependent on the results that we are getting from a graph. This graph is again dynamic in nature and is dependent on the selections made.

Please advice as to how this can be done..

Thanks in advance.

375 Views
0 Likes
1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III
‎2016-12-29 03:03 AM

You can use an expression to construct the text you want to display.

='The total road accidents has ' & if( ...something... > 0, 'increased', 'decreased') & ' by ' & ...expression-to-calculate-percentage-here... & ' YOY. The market has ....etc'


talk is cheap, supply exceeds demand
292 Views