Pivot Table - background color disappears depending on sort order

Tue, 10 Jun 2014 09:10:50 GMT

Hi there,

I want to color the background of my "status history" dimensions according to its status: (0-4 - red, 5-6 - yellow and 7-9 green) as shown in following screenshot:

Unfortunately this only works with a reversed sort order on the dates (I want to have the oldest dates first).

When I sort the date the way I want it the colors disappear if the very first date entry is not filled:

To have the grey lines filled with the background color I need to select this line. In that case the first date entry is filled again and so the background color works as desired, too.

I attached the qvw, maybe someone can help?

Thanks a lot and best regards,

Christian

topic Pivot Table - background color disappears depending on sort order in QlikView

Pivot Table - background color disappears depending on sort order