topic Re: Pivot table - Formatting cells in QlikView

Pivot table - Formatting cells

Fri, 13 Jan 2017 10:52:04 GMT

Hello,

In a pivot table, I would like to put the same background color for my dimensions: blue for product, green for company.

As you can see It doesn't work if the first cell is NULL in the table.

Do you know how I can have the format applied even if some values are NULL ?

Thanks for your answer

enriquem — Fri, 13 Jan 2017 11:32:04 GMT

Hello!

1.Select the properties in you Pivot Table

2.go to the Dimension tab

3.Select a color for each dimension that you select, like i show you. (you can do this to the expressions too)

I put the red() color to the first, and yellow to the second.

4.Finally apply and accept. And your pivot table will look like this:

Regards

Fri, 13 Jan 2017 16:59:17 GMT

Thanks for your answer.

It is exactly what I dit but it doesn't work in my example:

- one dimension in column, one dimension in row

- result of expression is null => Company b and Company c don't have any color because the first row (product a) is null

el_aprendiz111 — Fri, 13 Jan 2017 17:30:45 GMT

Hi, 1 example

Wed, 25 Jan 2017 09:57:32 GMT

I think I am not very clear with my request

I attached to this message my example where your solutions don't work.