topic Scatterplot point labels: text format not changing in QlikView

Scatterplot point labels: text format not changing

Anonymous — Thu, 11 May 2017 18:53:15 GMT

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.

Re: Scatterplot point labels: text format not changing

RSvebeck — Thu, 11 May 2017 18:59:45 GMT

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

Re: Scatterplot point labels: text format not changing

Anil_Babu_Samineni — Fri, 12 May 2017 04:28:51 GMT

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())

Re: Scatterplot point labels: text format not changing

Anonymous — Fri, 12 May 2017 06:53:18 GMT

Okay, but what then exactly is the "Text Color" and "Text Format" option in the Expressions Tab doing?

Re: Scatterplot point labels: text format not changing

Anonymous — Fri, 12 May 2017 06:54:48 GMT

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.