topic Colours for expressions with variables (Color) in QlikView https://community.qlik.com/t5/QlikView/Colours-for-expressions-with-variables-Color/m-p/261207#M581594 <HTML><HEAD></HEAD><BODY><P>I am producing charts that are based on Financial Years.&nbsp; I have three different types of dates, Opened Date, Closed Date and Issued Date.&nbsp; I have then calculated the Financial Year for all of these dates.</P><P></P><P>I have created a data Island to allow the selection of a Financial Year that can be compared to all of the above.&nbsp; I also then have variables that work out what the last 4 Financial Years have been.</P><P></P><P>In my charts I then have an expression for each of the 4 previous financial years. e.g. sum({$&lt;FY_Issued={'$(vFYMinus4)'}&gt;}Payment_Amount)</P><P></P><P>My problem is I want a consistent colour across all charts for the financial years.&nbsp; I can't find a way to associate a colour with the value of a variable.</P><P></P><P>Fair chance I'm missing something glaringly obvious, so any help would be appreciated</P></BODY></HTML> Mon, 28 Nov 2011 15:44:02 GMT 2011-11-28T15:44:02Z Colours for expressions with variables (Color) https://community.qlik.com/t5/QlikView/Colours-for-expressions-with-variables-Color/m-p/261207#M581594 <HTML><HEAD></HEAD><BODY><P>I am producing charts that are based on Financial Years.&nbsp; I have three different types of dates, Opened Date, Closed Date and Issued Date.&nbsp; I have then calculated the Financial Year for all of these dates.</P><P></P><P>I have created a data Island to allow the selection of a Financial Year that can be compared to all of the above.&nbsp; I also then have variables that work out what the last 4 Financial Years have been.</P><P></P><P>In my charts I then have an expression for each of the 4 previous financial years. e.g. sum({$&lt;FY_Issued={'$(vFYMinus4)'}&gt;}Payment_Amount)</P><P></P><P>My problem is I want a consistent colour across all charts for the financial years.&nbsp; I can't find a way to associate a colour with the value of a variable.</P><P></P><P>Fair chance I'm missing something glaringly obvious, so any help would be appreciated</P></BODY></HTML> Mon, 28 Nov 2011 15:44:02 GMT https://community.qlik.com/t5/QlikView/Colours-for-expressions-with-variables-Color/m-p/261207#M581594 2011-11-28T15:44:02Z