topic How assign colors particular columns in pivot table in QlikView

How assign colors particular columns in pivot table

ramrongala — Wed, 25 Nov 2020 16:16:04 GMT

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

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.

Re: How assign colors particular columns in pivot table

Fri, 05 May 2017 06:33:56 GMT

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.

Re: How assign colors particular columns in pivot table

Anonymous — Fri, 05 May 2017 06:38:45 GMT

Dimension background and expression background color is not working?

Re: How assign colors particular columns in pivot table

senpradip007 — Fri, 05 May 2017 07:05:37 GMT

Have a look at the attachment.

Re: How assign colors particular columns in pivot table

ramrongala — Fri, 05 May 2017 07:29:40 GMT

Bro its working perfect..Thank you very much

Re: How assign colors particular columns in pivot table

Anonymous — Tue, 18 Jul 2017 06:37:18 GMT

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