topic Color Expression Based Range of values pivot table in QlikView https://community.qlik.com/t5/QlikView/Color-Expression-Based-Range-of-values-pivot-table/m-p/1303829#M515691 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Iam trying to put background color based on the range of Numbers with blue color i am not able to get the color for the range of numbers</P><P></P><P>Iam using pivot table</P><P>For Rows = Hours <BR />Column = Weekday and date</P><P>Measure = sum(calls)</P><P>Used Expression in background color expression:</P><P>ARGB(Sum(calls)/Max(TOTAL (calls),weekday,hour)*256,68,119,170)</P><P></P><P>So can you help me out!</P></BODY></HTML> Fri, 16 Jun 2017 11:09:57 GMT viveksairam89 2017-06-16T11:09:57Z Color Expression Based Range of values pivot table https://community.qlik.com/t5/QlikView/Color-Expression-Based-Range-of-values-pivot-table/m-p/1303829#M515691 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Iam trying to put background color based on the range of Numbers with blue color i am not able to get the color for the range of numbers</P><P></P><P>Iam using pivot table</P><P>For Rows = Hours <BR />Column = Weekday and date</P><P>Measure = sum(calls)</P><P>Used Expression in background color expression:</P><P>ARGB(Sum(calls)/Max(TOTAL (calls),weekday,hour)*256,68,119,170)</P><P></P><P>So can you help me out!</P></BODY></HTML> Fri, 16 Jun 2017 11:09:57 GMT https://community.qlik.com/t5/QlikView/Color-Expression-Based-Range-of-values-pivot-table/m-p/1303829#M515691 viveksairam89 2017-06-16T11:09:57Z