Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Pivot table conditional background is not working

Hello All,

I am trying to get conditional background colour in qlik sense.but my two expressions are not compairing correctly.

Kindly advice .what to do?

below is the expression 

set analysis:

if(KPI_Type='Actual' and Round(sum({<KPI_Type={'Actual'}>}Value))>Round(sum({<KPI_Type={'Target'}>}Value)), '#00ff99',
if(KPI_Type='Actual' and Round(sum({<KPI_Type={'Actual'}>}Value))<Round(sum({<KPI_Type={'Target'}>}Value)), '#ff9999',
if(KPI_Type='Actual' and (Round(sum({<KPI_Type={'Actual'}>}Value))='0'), '#c2cbcb'))
)
 

 

1 Solution

Accepted Solutions
Highlighted
Contributor III
Contributor III

Re: Pivot table conditional background is not working

yes i did that,and got the result as well.

Thank you😊

View solution in original post

2 Replies
Highlighted
Master II
Master II

Re: Pivot table conditional background is not working

Use Aggr() Function to compare at FMonth Grouping level.

Highlighted
Contributor III
Contributor III

Re: Pivot table conditional background is not working

yes i did that,and got the result as well.

Thank you😊

View solution in original post