Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ebrahimaljefri
New Contributor III

coloring Column in pivot table

hi , i am using qlik sense desktop and i tried to coloring Column in pivot table but i could not .

8 Replies
ebrahimaljefri
New Contributor III

Re: coloring Column in pivot table

i have seen 10 views and no answer !!

rahulpawarb
Valued Contributor II

Re: coloring Column in pivot table

You can make use of Background Color expression associated with Measure(s); where you will specify an expression to decide color of that expression field.

Regards!

Rahul

beck110979
Valued Contributor III

Re: coloring Column in pivot table

Hi Ibrahibra,

try to use this expression (as Rahul Pawar said) in Background Color Expression:

Expression: if(Sum(YourValue) > 100 (your value as well, it depends on your requirement), greelight(), redlight())

i hope that helps

Beck

ebrahimaljefri
New Contributor III

Re: coloring Column in pivot table

Rahul Pawabeck bakytbek

Thanks for replying but i actually have had colored measure and i have no issue with that and what i am asking is can i color dimensions in the pivot chart.

martinpohl
Valued Contributor II

Re: coloring Column in pivot table

It is not possible without any extensions.

beck110979
Valued Contributor III

Re: coloring Column in pivot table

Hi Ibrahibra,

look at on Qlik.Branch. maybe you finde there the solution for your issue

Beck

ebrahimaljefri
New Contributor III

Re: coloring Column in pivot table

Martin Pohl

Sorry i didn't understand you clearly can you please clarify more 

rahulpawarb
Valued Contributor II

Re: coloring Column in pivot table