Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a simple scatterplot object with companies as the dimension and total sales vs product sales as expressions.
Now I have the company names displayed via Presentation > Show Labels, BUT I do not want them on all points but rather on the ones with total sales above average. What I tried was to make them transparent "Text Color" in the Expression tab, with an expression like this: IF(total_sales > xxx, Color(), Color() ).
Unfortunately, nothing happens with the text labels, although the color of the points changes when I use the same expression just one step above at "Background Color". How is this possible? Do the labels not belong to the expression? I also tried it at the other Expression and also the dimension, still with no effect.
Thanks in advance.
As far as i know, you can not change the color of those texts by an expression. I have tried many times to do it but never suceeded.
One work-around i found is to place a 2nd but transparent scater chart on top of the other, and in that one making sure it has the same scale, but not showing the dimensions that should not gave the text.
Robert
In fact, That is not possible in Qlikview and hope other BI also don't have that capture as per my experience. And Why not to use like below
IF(total_sales = 'xxx', Green(), Red())
Or, If 2 conditions you can use like below
IF(total_sales = 'xxx' and NumberField >= 30, Green(), Red())
Okay, but what then exactly is the "Text Color" and "Text Format" option in the Expressions Tab doing?
Hello Anil,
thanks for your response. How is your formula different from mine? I want to color labels on data points in a scatterpplot with this formula. This is what doesnt work, I think the formula is fine.