topic Re: Dynamic Text in QlikView https://community.qlik.com/t5/QlikView/Dynamic-Text/m-p/1248073#M865048 <HTML><HEAD></HEAD><BODY><P>You can use an expression to construct the text you want to display.</P><P>='The total road accidents has ' &amp; if( ...something... &gt; 0, 'increased', 'decreased') &amp; ' by ' &amp; ...expression-to-calculate-percentage-here... &amp; ' YOY. The market has ....etc'</P></BODY></HTML> Thu, 29 Dec 2016 08:03:09 GMT Gysbert_Wassenaar 2016-12-29T08:03:09Z Dynamic Text https://community.qlik.com/t5/QlikView/Dynamic-Text/m-p/1248072#M865046 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am trying to create a text with dynamic figures...</P><P></P><P>eg. The total road accidents has <SPAN style="color: #ff0000;">increased / decreased</SPAN> by <SPAN style="color: #ff0000;">15%</SPAN> YOY. The market has shown a <SPAN style="color: #ff0000;">12% increase /decrease</SPAN>.</P><P></P><P>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.</P><P></P><P>Please advice as to how this can be done..</P><P></P><P>Thanks in advance.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Dynamic-Text/m-p/1248072#M865046 2020-11-25T16:16:04Z Re: Dynamic Text https://community.qlik.com/t5/QlikView/Dynamic-Text/m-p/1248073#M865048 <HTML><HEAD></HEAD><BODY><P>You can use an expression to construct the text you want to display.</P><P>='The total road accidents has ' &amp; if( ...something... &gt; 0, 'increased', 'decreased') &amp; ' by ' &amp; ...expression-to-calculate-percentage-here... &amp; ' YOY. The market has ....etc'</P></BODY></HTML> Thu, 29 Dec 2016 08:03:09 GMT https://community.qlik.com/t5/QlikView/Dynamic-Text/m-p/1248073#M865048 Gysbert_Wassenaar 2016-12-29T08:03:09Z