https://community.qlik.com/t5/QlikView/Highlight-fields-in-pivot-table/m-p/2017420#M1221955 <P>Hi, all!</P> <P>How can I highlight cells that are weekends? I need to distinguish those values</P> <P>&nbsp;</P> <P>Thanks!</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="akseeels_0-1671195296263.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/96363iBAB1C2C4CD68AB46/image-size/medium?v=v2&amp;px=400" role="button" title="akseeels_0-1671195296263.png" alt="akseeels_0-1671195296263.png" /></span></P> <P>&nbsp;</P> Fri, 16 Dec 2022 13:13:30 GMT alekpprrr 2022-12-16T13:13:30Z https://community.qlik.com/t5/QlikView/Highlight-fields-in-pivot-table/m-p/2017420#M1221955 <P>Hi, all!</P> <P>How can I highlight cells that are weekends? I need to distinguish those values</P> <P>&nbsp;</P> <P>Thanks!</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="akseeels_0-1671195296263.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/96363iBAB1C2C4CD68AB46/image-size/medium?v=v2&amp;px=400" role="button" title="akseeels_0-1671195296263.png" alt="akseeels_0-1671195296263.png" /></span></P> <P>&nbsp;</P> Fri, 16 Dec 2022 13:13:30 GMT https://community.qlik.com/t5/QlikView/Highlight-fields-in-pivot-table/m-p/2017420#M1221955 alekpprrr 2022-12-16T13:13:30Z https://community.qlik.com/t5/QlikView/Highlight-fields-in-pivot-table/m-p/2017688#M1221965 <P>Hi, if the dimensions are related to month and day number, you can ad a field in script that uses those values to check the date, and if that date was on weekend.</P> <P>To check if it was on weekend you can use weekday() function</P> <P>If(WeekDay(DateValue)&gt;=5,1,0) as isWeekend</P> <P>With that field you only need to add a color expression to the table as: If(isWeekend, Yellow())</P> Sun, 18 Dec 2022 11:43:27 GMT https://community.qlik.com/t5/QlikView/Highlight-fields-in-pivot-table/m-p/2017688#M1221965 rubenmarin 2022-12-18T11:43:27Z