Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER 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.

qlikviewnovice
Specialist II
Specialist II

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

rubandoss786
Creator
Creator

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...