topic Conditions on expression in QlikView https://community.qlik.com/t5/QlikView/Conditions-on-expression/m-p/312008#M497333 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have a client solution where they have a explaining text as an expression, set as Text as popup on a Dashboard/ Gauge Chart. Is it possible to add a condition to this expression so that it's just shown when RR_Business = Insurance?</P><P></P><P>I had solved this in version 10 and 11, but as the client is on version 9 I have to do it differently...</P><P></P><P>Expression:</P><P class="p1">=' ' &amp; 'Helptext'</P><P class="p1"></P><P class="p1"></P><P class="p1"></P><P>@Ungvall</P><P>Senior Business Discovery Manager at Advectas AB</P></BODY></HTML> Fri, 11 Nov 2011 08:08:46 GMT 2011-11-11T08:08:46Z Conditions on expression https://community.qlik.com/t5/QlikView/Conditions-on-expression/m-p/312008#M497333 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have a client solution where they have a explaining text as an expression, set as Text as popup on a Dashboard/ Gauge Chart. Is it possible to add a condition to this expression so that it's just shown when RR_Business = Insurance?</P><P></P><P>I had solved this in version 10 and 11, but as the client is on version 9 I have to do it differently...</P><P></P><P>Expression:</P><P class="p1">=' ' &amp; 'Helptext'</P><P class="p1"></P><P class="p1"></P><P class="p1"></P><P>@Ungvall</P><P>Senior Business Discovery Manager at Advectas AB</P></BODY></HTML> Fri, 11 Nov 2011 08:08:46 GMT https://community.qlik.com/t5/QlikView/Conditions-on-expression/m-p/312008#M497333 2011-11-11T08:08:46Z Re: Conditions on expression https://community.qlik.com/t5/QlikView/Conditions-on-expression/m-p/312009#M497334 <HTML><HEAD></HEAD><BODY><P>The easiest way would be changing the expression to null or helptext dynamically if Only(RR_Business) = 'Insurance'. Eventhough the popout comes it comes as null.</P><P></P><P>If you want to disable the textas popout dynamically, probably you need to trigger the macro when field selection is changed:</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code"><P>set chart = ActiveDocument.GetSheetObject("CH01")</P><P>set Prop = chart.GetProperties </P><P>Prop.ChartProperties.ShowValueInPopup(0) = true 'or false</P><P>chart.SetProperties Prop</P></PRE><P></P><P>Kiran.</P></BODY></HTML> Fri, 11 Nov 2011 08:27:11 GMT https://community.qlik.com/t5/QlikView/Conditions-on-expression/m-p/312009#M497334 2011-11-11T08:27:11Z