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: 
sergio0592
Specialist III
Specialist III

Sub total line color in pivot chart

Hi all,

I'am looking for change sub total color in a pivot chart. In the attached sample, i'd like to get a red sub total color for country A, orange for country B and green for country C.

I tried with Custom format cell (Ctrl+G) and calculated color but dont't works. Any idea?

1 Solution

Accepted Solutions
MindaugasBacius
Partner - Specialist III
Partner - Specialist III

Use Background Color in Dimensions and Expressions like this:

=If(Country = 'A' and Len(trim(Shop_ID)) = 0, red(), 
	If(Country = 'B' and Len(trim(Shop_ID)) = 0, yellow(), 
		If(Country = 'C' and Len(trim(Shop_ID)) = 0, blue())))

You will come up with this result:

Screenshot_1.jpg

Adjust the colors to your needs 🙂

View solution in original post

2 Replies
MindaugasBacius
Partner - Specialist III
Partner - Specialist III

Use Background Color in Dimensions and Expressions like this:

=If(Country = 'A' and Len(trim(Shop_ID)) = 0, red(), 
	If(Country = 'B' and Len(trim(Shop_ID)) = 0, yellow(), 
		If(Country = 'C' and Len(trim(Shop_ID)) = 0, blue())))

You will come up with this result:

Screenshot_1.jpg

Adjust the colors to your needs 🙂

sergio0592
Specialist III
Specialist III
Author

Thanks! The

and Len(trim(Shop_ID)) = 0

make the difference 🙂