Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

ramrongala
New Contributor

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

Tags (1)
1 Solution

Accepted Solutions
senpradip007
Valued Contributor III

Re: How assign colors particular columns in pivot table

Have a look at the attachment.

5 Replies
Not applicable

Re: How assign colors particular columns in pivot table

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
Valued Contributor II

Re: How assign colors particular columns in pivot table

Hi

Dimension background and expression background color is not working?

senpradip007
Valued Contributor III

Re: How assign colors particular columns in pivot table

Have a look at the attachment.

ramrongala
New Contributor

Re: How assign colors particular columns in pivot table

Bro its working perfect..Thank you very much

Highlighted
rubandoss786
Contributor

Re: How assign colors particular columns in pivot table

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