Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Looks good to me!
Can you try this?
if(((num(Sales)=num(Revenue)),green(), red());
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.
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!
Not sure why that is. Trying some other workarounds - hopefully I can find a solution here soon.
Very weird behavior but I restarted Qlik Sense and it seems to be working now.
Oh! That's strange!
Although you got it to work which is all that matters!