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: 
ramrongala
Contributor II
Contributor II

How assign colors particular columns in pivot table

Hi

Actually i added new values in dimension so that entire column i have to apply colors.

color.png

here 5 values(bold) are there these are the i added using  some logic.i want assign colors on those 5 columns like

Non land Total and non OS land total---one color(like light red)

non OS overall and OS overall---one color (like  red )

Total ---One color(like thick red)..

I tried so many ways like Dimensionality(),customformat cell, expression and dimension background but i am fail.

i want 2 types like below.. please help on this 2 types i attach QVW file.

color.pngcolor1.png

1 Solution

Accepted Solutions
senpradip007
Specialist III
Specialist III

Have a look at the attachment.

View solution in original post

5 Replies
Not applicable

Not a real answer , but could you not move calculation of [Activity name] field to the script? You would save your self a lot of complexity when defining dimension, sorting, coloring, etc. Easier to maintain as well.

You could then just use simple expression (or calculated variable) in 'background' section.

Anonymous
Not applicable

Hi

Dimension background and expression background color is not working?

senpradip007
Specialist III
Specialist III

Have a look at the attachment.

ramrongala
Contributor II
Contributor II
Author

Bro its working perfect..Thank you very much

Anonymous
Not applicable

HI Pradip,

Please share us the methods you used to achieve this. I am using Personal edition, so I cannot open the document.

Thanks in advance...