topic Re: Expression background colours only displaying for selected month in QlikView https://community.qlik.com/t5/QlikView/Expression-background-colours-only-displaying-for-selected-month/m-p/1440176#M511846 <HTML><HEAD></HEAD><BODY><P>Amazing! It works. Thank you very much for your help!</P></BODY></HTML> Wed, 06 Dec 2017 17:00:18 GMT Anonymous 2017-12-06T17:00:18Z Expression background colours only displaying for selected month https://community.qlik.com/t5/QlikView/Expression-background-colours-only-displaying-for-selected-month/m-p/1440174#M511844 <HTML><HEAD></HEAD><BODY><P>Hi everyone</P><P></P><P>I have a chart that dynamically displays aggregates by company for the last 12 months based on the current selected month. It should also format the expression background colour based on the company name (company names and their corresponding colours are stored in a table). In the attached example with dummy data, the line chart appears fine, but the pivot table only formats the expression for the current selected month. What changes can I make so that the pivot table displays the colours for all 12 months?</P><P></P><P>Just a note that the attached example only has three company names in the sample data, but the actual data has over 20, and it is possible that more company names could be added in future. If possible I would like to avoid hard coding these, and only add colours for a new company name in the colour table, which will then be picked up by the chart.</P><P></P><P>Please let me know if anything is unclear.</P><P></P><P>Thanks in advance for your help!</P></BODY></HTML> Wed, 06 Dec 2017 16:40:15 GMT https://community.qlik.com/t5/QlikView/Expression-background-colours-only-displaying-for-selected-month/m-p/1440174#M511844 Anonymous 2017-12-06T16:40:15Z Re: Expression background colours only displaying for selected month https://community.qlik.com/t5/QlikView/Expression-background-colours-only-displaying-for-selected-month/m-p/1440175#M511845 <HTML><HEAD></HEAD><BODY><P>Try this for your color expression</P><P><STRONG>Only({1} Colour)</STRONG></P></BODY></HTML> Wed, 06 Dec 2017 16:50:59 GMT https://community.qlik.com/t5/QlikView/Expression-background-colours-only-displaying-for-selected-month/m-p/1440175#M511845 sunny_talwar 2017-12-06T16:50:59Z Re: Expression background colours only displaying for selected month https://community.qlik.com/t5/QlikView/Expression-background-colours-only-displaying-for-selected-month/m-p/1440176#M511846 <HTML><HEAD></HEAD><BODY><P>Amazing! It works. Thank you very much for your help!</P></BODY></HTML> Wed, 06 Dec 2017 17:00:18 GMT https://community.qlik.com/t5/QlikView/Expression-background-colours-only-displaying-for-selected-month/m-p/1440176#M511846 Anonymous 2017-12-06T17:00:18Z