Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Change of background color of pivot table not working

Hi,

After moving one dimension to horizontal axis in pivot table, vertical dimensions background color change is not working any more.

If I move the dimension back to vertical position coloring is working well.

I have the following code in Background color:

=If(ELEMENT_UPDATED > Today()-30 ,RGB(255, 255, 0))

Any idea what is wrong with this one?

BR, Outi

7 Replies
christophebrault
Valued Contributor

Re: Change of background color of pivot table not working

Perhaps it could be because you don't have aggregation on ELEMENT_UPDATED and pultiple value for your dimensions. Can you try to add max(ELEMENT_UPDATED ) or mode(ELEMENT_UPDATED ) ?

Share example with us could be great too.

Not applicable

Re: Change of background color of pivot table not working

Thanks,

I tried both but they didn't help.

Any other things in mind that I can try?

BR, Outi

Not applicable

Re: Change of background color of pivot table not working

Hi,

finally I get back to this issue.

Here is an example. The only difference between those two tables is that I have dragged Area dimension on horizontal axis.

In

Pivot_table_issue.PNG

In Pivot Table 1 the colors are as they shoud be.

 

Any ideas?

BR, Outi

jsn
Honored Contributor

Re: Change of background color of pivot table not working

It's because they have missing values in the first column of the expression (Area1). Unfortunately this leaves the background color blank

Not applicable

Re: Change of background color of pivot table not working

Do you know any workaround for this?

jsn
Honored Contributor

Re: Change of background color of pivot table not working

Unfortunately no, unless you introduce a bogus 0 value or similar for the missing values in the first column

Not applicable

Re: Change of background color of pivot table not working

Thanks for you help, I will try that

Community Browser