topic Re: Change bar colour based on the conditional measures in App Development https://community.qlik.com/t5/App-Development/Change-bar-colour-based-on-the-conditional-measures/m-p/1443020#M34982 <HTML><HEAD></HEAD><BODY><P>Share this sample file if possible to test some expressions</P></BODY></HTML> Mon, 13 Nov 2017 10:19:00 GMT shraddha_g 2017-11-13T10:19:00Z Change bar colour based on the conditional measures https://community.qlik.com/t5/App-Development/Change-bar-colour-based-on-the-conditional-measures/m-p/1443014#M34976 <HTML><HEAD></HEAD><BODY><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/182640_Capture.PNG" style="max-width: 620px; height: auto;" /></P><P></P><P>Hi, I'm trying to colour the measure using epression <BR /><SPAN style="font-size: 13.3333px;"><BR />Exp: if(sum([crudedaily]) &gt; Sum([crudeplan]), Sum([crudedaily])='green',Sum([crudeplan])= red())<BR />But the colour not come out, is it my expresion wrong?<BR />What I want is if the sum of crude daily &gt; sum of crude plan , the bar colour is green , else, red. <BR /></SPAN></P></BODY></HTML> Thu, 09 Nov 2017 06:35:53 GMT https://community.qlik.com/t5/App-Development/Change-bar-colour-based-on-the-conditional-measures/m-p/1443014#M34976 Anonymous 2017-11-09T06:35:53Z Re: Change bar colour based on the conditional measures https://community.qlik.com/t5/App-Development/Change-bar-colour-based-on-the-conditional-measures/m-p/1443015#M34977 <HTML><HEAD></HEAD><BODY><P>Expression should be,</P><P>if(sum([crudedaily]) &gt; Sum([crudeplan]), green(),red())</P></BODY></HTML> Fri, 10 Nov 2017 05:41:18 GMT https://community.qlik.com/t5/App-Development/Change-bar-colour-based-on-the-conditional-measures/m-p/1443015#M34977 shraddha_g 2017-11-10T05:41:18Z Re: Change bar colour based on the conditional measures https://community.qlik.com/t5/App-Development/Change-bar-colour-based-on-the-conditional-measures/m-p/1443016#M34978 <HTML><HEAD></HEAD><BODY><P>Also please share sample app to test</P></BODY></HTML> Fri, 10 Nov 2017 05:41:39 GMT https://community.qlik.com/t5/App-Development/Change-bar-colour-based-on-the-conditional-measures/m-p/1443016#M34978 shraddha_g 2017-11-10T05:41:39Z Re: Change bar colour based on the conditional measures https://community.qlik.com/t5/App-Development/Change-bar-colour-based-on-the-conditional-measures/m-p/1443017#M34979 <HTML><HEAD></HEAD><BODY><P>This expression didn't work out, <IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/182976_Capture.PNG" style="height: 312px; width: 620px;" /></P><P></P><P><BR />What I want is the measure for crude daily is green, and crude plan is red</P></BODY></HTML> Mon, 13 Nov 2017 00:39:27 GMT https://community.qlik.com/t5/App-Development/Change-bar-colour-based-on-the-conditional-measures/m-p/1443017#M34979 Anonymous 2017-11-13T00:39:27Z Re: Change bar colour based on the conditional measures https://community.qlik.com/t5/App-Development/Change-bar-colour-based-on-the-conditional-measures/m-p/1443018#M34980 <HTML><HEAD></HEAD><BODY><P>how to insert qvf file?</P></BODY></HTML> Mon, 13 Nov 2017 00:47:21 GMT https://community.qlik.com/t5/App-Development/Change-bar-colour-based-on-the-conditional-measures/m-p/1443018#M34980 Anonymous 2017-11-13T00:47:21Z Re: Change bar colour based on the conditional measures https://community.qlik.com/t5/App-Development/Change-bar-colour-based-on-the-conditional-measures/m-p/1443019#M34981 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/docs/DOC-16454">Uploading a Sample</A></P></BODY></HTML> Mon, 13 Nov 2017 10:17:52 GMT https://community.qlik.com/t5/App-Development/Change-bar-colour-based-on-the-conditional-measures/m-p/1443019#M34981 shraddha_g 2017-11-13T10:17:52Z Re: Change bar colour based on the conditional measures https://community.qlik.com/t5/App-Development/Change-bar-colour-based-on-the-conditional-measures/m-p/1443020#M34982 <HTML><HEAD></HEAD><BODY><P>Share this sample file if possible to test some expressions</P></BODY></HTML> Mon, 13 Nov 2017 10:19:00 GMT https://community.qlik.com/t5/App-Development/Change-bar-colour-based-on-the-conditional-measures/m-p/1443020#M34982 shraddha_g 2017-11-13T10:19:00Z Re: Change bar colour based on the conditional measures https://community.qlik.com/t5/App-Development/Change-bar-colour-based-on-the-conditional-measures/m-p/1443021#M34983 <HTML><HEAD></HEAD><BODY></BODY></HTML> Tue, 14 Nov 2017 01:32:49 GMT https://community.qlik.com/t5/App-Development/Change-bar-colour-based-on-the-conditional-measures/m-p/1443021#M34983 Anonymous 2017-11-14T01:32:49Z Re: Change bar colour based on the conditional measures https://community.qlik.com/t5/App-Development/Change-bar-colour-based-on-the-conditional-measures/m-p/1443022#M34984 <HTML><HEAD></HEAD><BODY><P>Hi i have sent the file</P></BODY></HTML> Tue, 14 Nov 2017 01:33:31 GMT https://community.qlik.com/t5/App-Development/Change-bar-colour-based-on-the-conditional-measures/m-p/1443022#M34984 Anonymous 2017-11-14T01:33:31Z