Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Unable to color conditional formatting

Hi,

I am a novice in Qlik Sense.I have created a pivot table similar to the table below.

ABCD
new york12.6%50
London14.5%70
Paris15%80
Total1360

Here I have created the total row through the slider option in general tab.

now I have to condition format each column for eg:
if  value in B is >total's 90% then green if below totals 10% then red.
Hope my explaination helps I am not able to find solution in any of the qlik community discussions.

I ahve a deadline to meet if anyone could Please help me on this.

Regards

Vinayak

2 Replies
rupamjyotidas
Valued Contributor

Re: Unable to color conditional formatting

Not applicable

Re: Unable to color conditional formatting

HI Rupam,

I am using color by expression but I have issue creating the expression for it

as I am unable to create an expression to compare the total of the column with the value
eg if the total is 10% and my value is 9% then it should be green if it is 1% then it should be red.

Regards,
Vinayak