Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Announcement: Certain actions are currently causing a Page Not Found error. This is a known issue and we are working with the platform vendor to investigate and resolve it.
Highlighted
anothergreg
New Contributor III

Scatter Chart - count total items per coordinate

I'm trying to create a scatter chart that will change bubble size relative to how many items land on the same coordinates, but all I am getting is overlapping bubbles with the same size.

My chart currently has 1 dimension:

     [Project Name]

          and 3 expressions:

     sum([EffortWeight])

     sum([PriorityWeight])

     count([Project Name])

My expectation would be that in a coordinate where there is only 1 Project aligned, such as (4,3), the bubble would be a size of 1.  And the coordinate where there are multiple Projects aligned, such as (4,4) (see picture attached), the bubble would be the size of the number of Projects.  In the case of the picture attached, this should be 4.

Instead, there are multiple bubbles of a size 1 overlapping on the same coordinate if there are the same projects on an identical coordinate, each counting a value of 1.  How do I get around this?  I've tried using if statements and I can't see how set analysis would accomplish this considering there are 25 different combinations and thus it would require an embedded if statement.

3 Replies
ali_millwala
New Contributor

Re: Scatter Chart - count total items per coordinate

Hi Can someone please help with this problem. Thanks

Re: Scatter Chart - count total items per coordinate

Can you attach your application to test because we need to test

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
mayuresh_d
Contributor

Re: Scatter Chart - count total items per coordinate

please refer attachment.

ty