Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Specialist
Specialist

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.

Inscrivez vous à ma Newletter Qlik
DoNotMissQlik- Connect with me on Linkedin
Highlighted
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

Highlighted
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

Highlighted
Master
Master

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

Highlighted
Not applicable

Re: Change of background color of pivot table not working

Do you know any workaround for this?

Highlighted
Master
Master

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

Highlighted
Not applicable

Re: Change of background color of pivot table not working

Thanks for you help, I will try that