Qlik Community

Ask a Question

App Development

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

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
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

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