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.
I tried some aggr functions, but it dosn´t work. Have anyone an idea?
Try replacing the null values in the script, either using NullAsValue(), or MAP....USING. Then your nulls won't be null (unless the "null" is by virtue or a joined table missing a row. Can you post your app for more help?
