topic Scatter chart - expression's values don't show in QlikView

Scatter chart - expression's values don't show

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello everyone,

I am using scatter charts to compare certain KPIs for companies with each other.

This works well in some cases:

But for a certain expression, the chart doesn't display any values:

As you can see, the expression generates rows in the straight table on the right. The scatter charts even lists the affected companies in the legend but the values are not displayed in the scatter chart itself.

I think it might have something to do with the used dimensions.

Maybe someone could take a look at it, I will attach the sample.

Thank you in advance!

Best regards,

Mats

Re: Scatter chart - expression's values don't show

sunny_talwar — Tue, 06 Jun 2017 16:42:58 GMT

These guys are here, but seems they are very small and really scattered

Re: Scatter chart - expression's values don't show

tajmohamed30 — Tue, 06 Jun 2017 16:57:19 GMT

Hi you can probably increase the size of the bubble simply by going to presentation tab>uncheck autosize symbols, then increase max bubble size point to required size

Re: Scatter chart - expression's values don't show

Anonymous — Tue, 06 Jun 2017 17:03:51 GMT

you can select the company names via mouse cursor in the legend and then QV zoomes into to the remaining datasets automatically...

Re: Scatter chart - expression's values don't show

Anonymous — Tue, 06 Jun 2017 17:05:51 GMT

Hi again Sunny,

the bubbles on the Y-axis couldn't hide from my watchful eyes!

I expected similar bubbles on the X-axis though, for the other expression (highest value about 626,000)

Or is that not how the chart works?

None of the companies have positive values in both expressions, maybe that's the problem

Re: Scatter chart - expression's values don't show

sunny_talwar — Tue, 06 Jun 2017 17:14:59 GMT

But the guy with 600k value doesn't seem to have any eNegativeVorräte value

Does it just have 0 value and that is why it doesn't show up?

Re: Scatter chart - expression's values don't show

Anonymous — Tue, 06 Jun 2017 17:24:34 GMT

yes that's right, does a scatter chart only produce a bubble if the 'guy' has a value in the first used expression?

then it might just not be the right tool for this particular comparison

Re: Scatter chart - expression's values don't show

Anonymous — Tue, 06 Jun 2017 17:27:42 GMT

Hi Robin,

When I select a company that (only) has a value in eNegativeRückstelkungen, the result is 'no data to display'.

I think the chart might not be suitable when the companies don't have values for both of the expressions at the same time

‌

Re: Scatter chart - expression's values don't show

sunny_talwar — Tue, 06 Jun 2017 17:28:03 GMT

Using this expression

Alt($(eNegativeVorräte)*(-1), 0)

It shows up

Re: Scatter chart - expression's values don't show

Anonymous — Tue, 06 Jun 2017 18:13:56 GMT

Ha, interesting! Didn't know about the alt function. That's what I wanted to display, thanks a lot.

Re: Scatter chart - expression's values don't show

sunny_talwar — Tue, 06 Jun 2017 18:15:08 GMT

Alt function will give the first non-null values... so when $(eNegativeVorräte)*(-1) was null, it gave 0