topic backround color in pivot table with null values in QlikView https://community.qlik.com/t5/QlikView/backround-color-in-pivot-table-with-null-values/m-p/361605#M134374 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I´ve a problem with the backround color in a pivot table. The table has five dimensions (three columns and two rows). I must seperate the dimension fields from the expression fields with another color. But QlikView doesn´t mark an element, if there is no value in the first expression field. If there is a value it works.</P><P>I tried some aggr functions, but it dosn´t work. Have anyone an idea?&nbsp; </P><P></P><P>Thx</P></BODY></HTML> Fri, 20 Apr 2012 14:08:52 GMT 2012-04-20T14:08:52Z backround color in pivot table with null values https://community.qlik.com/t5/QlikView/backround-color-in-pivot-table-with-null-values/m-p/361605#M134374 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I´ve a problem with the backround color in a pivot table. The table has five dimensions (three columns and two rows). I must seperate the dimension fields from the expression fields with another color. But QlikView doesn´t mark an element, if there is no value in the first expression field. If there is a value it works.</P><P>I tried some aggr functions, but it dosn´t work. Have anyone an idea?&nbsp; </P><P></P><P>Thx</P></BODY></HTML> Fri, 20 Apr 2012 14:08:52 GMT https://community.qlik.com/t5/QlikView/backround-color-in-pivot-table-with-null-values/m-p/361605#M134374 2012-04-20T14:08:52Z backround color in pivot table with null values https://community.qlik.com/t5/QlikView/backround-color-in-pivot-table-with-null-values/m-p/361606#M134375 <HTML><HEAD></HEAD><BODY><P>Try replacing the null values in the script, either using NullAsValue(), or MAP....USING.&nbsp; Then your nulls won't be null (unless the "null" is by virtue or a joined table missing a row.&nbsp; Can you post your app for more help?</P></BODY></HTML> Fri, 20 Apr 2012 15:13:38 GMT https://community.qlik.com/t5/QlikView/backround-color-in-pivot-table-with-null-values/m-p/361606#M134375 Jason_Michaelides 2012-04-20T15:13:38Z