topic YTD With Conditional Coluring in QlikView https://community.qlik.com/t5/QlikView/YTD-With-Conditional-Coluring/m-p/974858#M960473 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>i am struckid in creating ytd with conditional coluring .Kindly help me</P></BODY></HTML> Wed, 28 Oct 2015 03:29:29 GMT 2015-10-28T03:29:29Z YTD With Conditional Coluring https://community.qlik.com/t5/QlikView/YTD-With-Conditional-Coluring/m-p/974858#M960473 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>i am struckid in creating ytd with conditional coluring .Kindly help me</P></BODY></HTML> Wed, 28 Oct 2015 03:29:29 GMT https://community.qlik.com/t5/QlikView/YTD-With-Conditional-Coluring/m-p/974858#M960473 2015-10-28T03:29:29Z Re: YTD With Conditional Coluring https://community.qlik.com/t5/QlikView/YTD-With-Conditional-Coluring/m-p/974859#M960474 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Use this expression in</P><P></P><P>Text Object Properties -&gt; Font -&gt; Color -&gt; Calculated and give expression below</P><P></P><P>=If(Sum({$&lt;Year={$(=Max(Year)-1)}&gt;} Sale) &lt; Sum(Sale), Red(), Green())</P><P></P><P>Note: In qlikview Dimension names are case sensitive, sales and Sales both are different, in YTD expression you have given sales but it should be Sales.</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Wed, 28 Oct 2015 03:51:16 GMT https://community.qlik.com/t5/QlikView/YTD-With-Conditional-Coluring/m-p/974859#M960474 jagan 2015-10-28T03:51:16Z Re: YTD With Conditional Coluring https://community.qlik.com/t5/QlikView/YTD-With-Conditional-Coluring/m-p/974860#M960475 <HTML><HEAD></HEAD><BODY><P>Thanks&nbsp; u&nbsp; Bro.</P></BODY></HTML> Wed, 28 Oct 2015 04:18:12 GMT https://community.qlik.com/t5/QlikView/YTD-With-Conditional-Coluring/m-p/974860#M960475 2015-10-28T04:18:12Z