topic Re: Expression help please in QlikView https://community.qlik.com/t5/QlikView/Expression-help-please/m-p/1029117#M923059 <HTML><HEAD></HEAD><BODY><P>Sunny T - that looks perfect! Thank you so much for your quick response. The qvw was accidently deleted from the thread. Could you please re-attach? Thank you!</P></BODY></HTML> Wed, 13 Apr 2016 19:00:34 GMT 2016-04-13T19:00:34Z Expression help please https://community.qlik.com/t5/QlikView/Expression-help-please/m-p/1029114#M923056 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a bar chart that is doing exactly what I want, with the exception of one thing. I need to make the bars add up to 100%. The way to do this is to exclude data IF the LCL column ('Lower_value' in the script) = '0'. That should be simple enough, but I can't seem to make an expression work.</P><P></P><P><IMG __jive_id="121563" alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/121563_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P>I hope you can help!</P><P></P><P>Thank you</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Expression-help-please/m-p/1029114#M923056 2020-11-25T16:16:04Z Re: Expression help please https://community.qlik.com/t5/QlikView/Expression-help-please/m-p/1029115#M923057 <HTML><HEAD></HEAD><BODY><P>Can you see if this is right?</P><P></P><P><IMG __jive_id="121566" alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/121566_Capture.PNG" style="height: 400px; width: 620px;" /></P></BODY></HTML> Wed, 13 Apr 2016 17:32:29 GMT https://community.qlik.com/t5/QlikView/Expression-help-please/m-p/1029115#M923057 sunny_talwar 2016-04-13T17:32:29Z Re: Expression help please https://community.qlik.com/t5/QlikView/Expression-help-please/m-p/1029116#M923058 <HTML><HEAD></HEAD><BODY><P>Hi Sunny</P><P></P><P>Could you please let us know the solution here... Seems like attachment is missing</P></BODY></HTML> Wed, 13 Apr 2016 18:58:09 GMT https://community.qlik.com/t5/QlikView/Expression-help-please/m-p/1029116#M923058 satishkurra 2016-04-13T18:58:09Z Re: Expression help please https://community.qlik.com/t5/QlikView/Expression-help-please/m-p/1029117#M923059 <HTML><HEAD></HEAD><BODY><P>Sunny T - that looks perfect! Thank you so much for your quick response. The qvw was accidently deleted from the thread. Could you please re-attach? Thank you!</P></BODY></HTML> Wed, 13 Apr 2016 19:00:34 GMT https://community.qlik.com/t5/QlikView/Expression-help-please/m-p/1029117#M923059 2016-04-13T19:00:34Z Re: Expression help please https://community.qlik.com/t5/QlikView/Expression-help-please/m-p/1029118#M923060 <HTML><HEAD></HEAD><BODY><P>I reattached it to the post again</P></BODY></HTML> Wed, 13 Apr 2016 19:09:13 GMT https://community.qlik.com/t5/QlikView/Expression-help-please/m-p/1029118#M923060 sunny_talwar 2016-04-13T19:09:13Z Re: Expression help please https://community.qlik.com/t5/QlikView/Expression-help-please/m-p/1029119#M923061 <HTML><HEAD></HEAD><BODY><P>That works perfectly. Thank you!</P></BODY></HTML> Wed, 13 Apr 2016 20:36:47 GMT https://community.qlik.com/t5/QlikView/Expression-help-please/m-p/1029119#M923061 2016-04-13T20:36:47Z