Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Scatter chart - expression's values don't show

Hello everyone,

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

This works well in some cases:

Capture1.JPG

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

Capture2.JPG

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

Tags (1)
1 Solution

Accepted Solutions
Highlighted

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

Using this expression

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

It shows up

Capture.PNG

View solution in original post

10 Replies
Highlighted

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

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

Capture.PNG

Highlighted
Creator III
Creator III

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

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

Highlighted
Anonymous
Not applicable

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

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

Highlighted
Creator
Creator

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

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

Highlighted

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

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

Capture.PNG

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

Highlighted
Creator
Creator

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

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

Highlighted
Creator
Creator

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

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

Highlighted

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

Using this expression

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

It shows up

Capture.PNG

View solution in original post

Highlighted
Creator
Creator

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

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