Qlik Community

Ask a Question

App Development

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

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
kavita25
Partner
Partner

Color logic in pivot table not working

Hello Everyone,

I want to color the column if my Actual is equal and greater than the Forecast in pivot table.

As shown in the below screenshot, on click of Jan-2020 its working for some category and for some category its not working. For e.g.  Adj EBITA Actuals and Forecast is same, then too its not showing in green.

kavita25_0-1598867532929.png

Color logic: =if(aggr(sum(forecast_bmc), category,period)=aggr(sum(actual_bmc), category,period),Green()).

Please look into the issue.

@sunny_talwar @Gysbert_Wassenaar 

 

Thanks & Regards,

Kavita

Labels (3)
1 Solution

Accepted Solutions
sunny_talwar

Equal seems to be related to rounding issue and greater, you just didn't use  greater or less sign... try this

=If(Round(Sum(forecast_bmc), 0.00001) <= Round(Sum(actual_bmc), 0.00001), Green())

View solution in original post

2 Replies
sunny_talwar

Equal seems to be related to rounding issue and greater, you just didn't use  greater or less sign... try this

=If(Round(Sum(forecast_bmc), 0.00001) <= Round(Sum(actual_bmc), 0.00001), Green())

View solution in original post

kavita25
Partner
Partner
Author

Thank You so much.. It worked. I was trying with num and not round function.

Thanks..for your help 🙂

Regards,

Kavita