Skip to main content

App Development

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

Announcements
An issue has been identified on Qlik Cloud hub, please visit our Status Update Page for details: GET THE LATEST
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
Partner - Master II
Partner - 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😊