topic Background colour on Total row based on content` in QlikView https://community.qlik.com/t5/QlikView/Background-colour-on-Total-row-based-on-content/m-p/498221#M186196 <HTML><HEAD></HEAD><BODY><P>I have a requirement to show if a sales rep has a zero sales forecast for a period. All the individual companies are shown,along with some other data, in a straight table, including the forecast amount. If all the forecasts total $0, I want to set the background colour of the "Total" row ONLY to red.</P><P></P><P>I know I can colour the row regardless with "If (rowno()=0 or rowno()=Null", but I want to colour it based on the value.</P><P></P><P>Is this what the 'below' function does? The documentation is very poor. </P><P></P><P>Thanks,</P><P></P><P>Kevin</P></BODY></HTML> Thu, 15 Aug 2013 20:38:30 GMT 2013-08-15T20:38:30Z Background colour on Total row based on content` https://community.qlik.com/t5/QlikView/Background-colour-on-Total-row-based-on-content/m-p/498221#M186196 <HTML><HEAD></HEAD><BODY><P>I have a requirement to show if a sales rep has a zero sales forecast for a period. All the individual companies are shown,along with some other data, in a straight table, including the forecast amount. If all the forecasts total $0, I want to set the background colour of the "Total" row ONLY to red.</P><P></P><P>I know I can colour the row regardless with "If (rowno()=0 or rowno()=Null", but I want to colour it based on the value.</P><P></P><P>Is this what the 'below' function does? The documentation is very poor. </P><P></P><P>Thanks,</P><P></P><P>Kevin</P></BODY></HTML> Thu, 15 Aug 2013 20:38:30 GMT https://community.qlik.com/t5/QlikView/Background-colour-on-Total-row-based-on-content/m-p/498221#M186196 2013-08-15T20:38:30Z Re: Background colour on Total row based on content` https://community.qlik.com/t5/QlikView/Background-colour-on-Total-row-based-on-content/m-p/498222#M186197 <HTML><HEAD></HEAD><BODY><P>You need to use the function DIMENSIONALITY(). </P><P></P><P>Dimensionality() = 0 represents the total row.</P></BODY></HTML> Thu, 15 Aug 2013 21:57:02 GMT https://community.qlik.com/t5/QlikView/Background-colour-on-Total-row-based-on-content/m-p/498222#M186197 Oleg_Troyansky 2013-08-15T21:57:02Z