Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Specialist
Specialist

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.

Inscrivez vous à ma Newletter Qlik
DoNotMissQlik- Connect with me on Linkedin
Not applicable
Author

Thanks,

I tried both but they didn't help.

Any other things in mind that I can try?

BR, Outi

Not applicable
Author

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

Anonymous
Not applicable
Author

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

Not applicable
Author

Do you know any workaround for this?

Anonymous
Not applicable
Author

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

Not applicable
Author

Thanks for you help, I will try that