color by expression not properly working

[dreweezy]

Iv got a scatter plot and trying to color by expression. 

X axis = Revenue

Y axis = Cost

Dimension = Accounts

My expression seems to be working to an extend to where if revenue is equal to cost, make it green, else make it red.

The problem is I see a lot of cases on my scatter plot where indeed revenue = cost but the color is still showing red. 

Expression:           If([Sales] = [Revenue], Green(), red())

Any ideas on why this may be? Is this a bug you guys think?

[deborahs]

Looks good to me! 

Can you try this?

if(((num(Sales)=num(Revenue)),green(), red());

[dreweezy]

Thanks, I've tried that but still no luck. I brought in a table to see if it was a rounding issue, but these 2 measures indeed have the exact same number. 

[deborahs]

Strange, I have a similar expression in one of our apps and it works fine.

That one is:

if(sum(Table.FieldName)<0,Red()).

Yours looks good to me, idk why it gives you error!

[dreweezy]

Not sure why that is. Trying some other workarounds - hopefully I can find a solution here soon. 

[dreweezy]

Very weird behavior but I restarted Qlik Sense and it seems to be working now.

[deborahs]

Oh! That's strange! 

Although you got it to work which is all that matters!