Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

hermia6578
New Contributor

How to make scatter plot if one dimension can have multiple x and y values?

Hello guys, I am new to qlik sense and I have a question on how to make scatter plot with filters. I searched but couldn't find similar problems.

The simplified data version is as follows:

Record    ev_group  x_value y_value

1             FA25         0.5        0.6

2             FA30         0.3        0.4

2             FA25         0.8        0.2

3             FA30         0.5        0.1

I want to make a scatter plot of the records and filter them by ev_group, right now I am using the function aggr(x/y, record, ev_group) so I can plot the record on measure x and y and group them by record and ev_group.

However, I found that if I select both FA 25 and F30, only record 1 and 3 will appear on the plot, but record 2 disappeared since it both belongs to group 25 and group 30. if I just select FA25, record 1 and 2 will appear, or if I just select FA30, record 2 and 3 will appear.

See my plot for example ,red dot is FA25 and black is F30:

f

With only FA 25 selected, several records showing

Now with both FA25  and 30 selected, only two red dots remains because all others have both FA25 and FA30.

So how do I alter my measure expression to make the plot show both record 1, 2, 3 with record 2 represented by two points(I can use a color expression to differentiate those points) on the same plot if I select both FA 25 and FA30?

Thanks in advance!

2 Replies
rachel_delany
Contributor

Re: How to make scatter plot if one dimension can have multiple x and y values?

Do you need the record number against them? Or can you change it so that the 2 record 2 are 2.1 and 2.2 or something similar? That might stop Qlik aggregating.

If you share your dashboard I might be able to have a look in more detail.

hermia6578
New Contributor

Re: How to make scatter plot if one dimension can have multiple x and y values?

Yeah  the record number is needed for analysis. I actually thought about this renaming  solution, like add another column to rename the record number, but my data set is huge and that may take too much space.

If there's no other way to do this, then maybe I will add the renamed column

Community Browser