Qlik Community

App Development

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

Announcements
Qlik Insider: SaaS capabilities for Data Integration and Analytics, May 25th! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
pranaligawde
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
pranaligawde
Contributor III
Contributor III
Author

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

Thank you😊

View solution in original post

2 Replies
ogster1974
Master II
Master II

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

pranaligawde
Contributor III
Contributor III
Author

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

Thank you😊