topic Re: Conditional macro in QV in QlikView https://community.qlik.com/t5/QlikView/Conditional-macro-in-QV/m-p/1042571#M933828 <HTML><HEAD></HEAD><BODY><P>Set fld and fld2 as you have already and then...</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IF (fld.GetValueCount(1) * fld2.GetValueCount(1)) = 0 then</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; msgbox "Please select....</P><P></P><P>If either or both are zero then the result of multiplying becomes zero.</P><P></P><P>If you only want to do the message when one is selected and the other not,...</P><P></P><P style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IF (fld.GetValueCount(1) * fld2.GetValueCount(1)) = 0 AND _</P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (fld.GetValueCount(1) + fld2.GetValueCount(1)) &lt;&gt; 0 </SPAN>then</P><P style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; msgbox "Please select....</P><P></P><P>...that second bit prevents the message when both are unselected.</P></BODY></HTML> Sat, 27 Feb 2016 10:49:30 GMT 2016-02-27T10:49:30Z Conditional macro in QV https://community.qlik.com/t5/QlikView/Conditional-macro-in-QV/m-p/1042570#M933827 <HTML><HEAD></HEAD><BODY><P>I have the following list boxes:</P><P></P><P><IMG alt="Screen Shot 2016-02-27 at 10.32.51.png" class="jive-image image-1" src="/legacyfs/online/116203_Screen Shot 2016-02-27 at 10.32.51.png" style="height: auto;" />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <IMG alt="Screen Shot 2016-02-27 at 10.33.01.png" class="jive-image image-2" src="/legacyfs/online/116207_Screen Shot 2016-02-27 at 10.33.01.png" style="height: auto;" /></P><P>I need to run a macro in QV on condition that a user makes a selection in any of the above two list boxes.&nbsp; I have the following individual macros which work individually:</P><P><IMG alt="Screen Shot 2016-02-27 at 10.31.54.png" class="jive-image image-3" src="/legacyfs/online/116208_Screen Shot 2016-02-27 at 10.31.54.png" style="height: auto;" /><IMG alt="Screen Shot 2016-02-27 at 10.32.14.png" class="image-4 jive-image" src="/legacyfs/online/116209_Screen Shot 2016-02-27 at 10.32.14.png" style="height: auto;" /></P><P>How can these two be combined to achieve my objective?</P><P></P><P>Regards.</P><P></P><P>Chris</P></BODY></HTML> Sat, 27 Feb 2016 08:41:38 GMT https://community.qlik.com/t5/QlikView/Conditional-macro-in-QV/m-p/1042570#M933827 Anonymous 2016-02-27T08:41:38Z Re: Conditional macro in QV https://community.qlik.com/t5/QlikView/Conditional-macro-in-QV/m-p/1042571#M933828 <HTML><HEAD></HEAD><BODY><P>Set fld and fld2 as you have already and then...</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IF (fld.GetValueCount(1) * fld2.GetValueCount(1)) = 0 then</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; msgbox "Please select....</P><P></P><P>If either or both are zero then the result of multiplying becomes zero.</P><P></P><P>If you only want to do the message when one is selected and the other not,...</P><P></P><P style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IF (fld.GetValueCount(1) * fld2.GetValueCount(1)) = 0 AND _</P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (fld.GetValueCount(1) + fld2.GetValueCount(1)) &lt;&gt; 0 </SPAN>then</P><P style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; msgbox "Please select....</P><P></P><P>...that second bit prevents the message when both are unselected.</P></BODY></HTML> Sat, 27 Feb 2016 10:49:30 GMT https://community.qlik.com/t5/QlikView/Conditional-macro-in-QV/m-p/1042571#M933828 2016-02-27T10:49:30Z Re: Conditional macro in QV https://community.qlik.com/t5/QlikView/Conditional-macro-in-QV/m-p/1042572#M933829 <HTML><HEAD></HEAD><BODY><P>Ended up using two different sheets and two different macros.</P><P></P><P>Regards</P></BODY></HTML> Sat, 27 Feb 2016 12:21:18 GMT https://community.qlik.com/t5/QlikView/Conditional-macro-in-QV/m-p/1042572#M933829 Anonymous 2016-02-27T12:21:18Z Re: Conditional macro in QV https://community.qlik.com/t5/QlikView/Conditional-macro-in-QV/m-p/1042573#M933830 <HTML><HEAD></HEAD><BODY><P>Many thanks Mark, this works fine</P></BODY></HTML> Thu, 03 Mar 2016 11:58:52 GMT https://community.qlik.com/t5/QlikView/Conditional-macro-in-QV/m-p/1042573#M933830 Anonymous 2016-03-03T11:58:52Z