Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Distinct aggregate function?

I need to plot a scatter chart that takes all the data from two columns (dimensions) and plots the distinct combinations of values.

Example:

Day x-valAmount y-val
130
160
130
130
240
230
230
330
360
3272
330
330

Plots:

Day x-valAmount y-val
130
160
230
240
330
360
3272

Ideally the frequency for each value would determine the size of the bubble:

Day x-valAmount y-valFreq. bubble-size
1303
1601
230

2

2401
3301
3601
32721

Any thoughts.  Doesn't seem obvious in Qlik Sense.

Thanks in advance.

5 Replies
simondachstr
Valued Contributor III

Re: Distinct aggregate function?

Seems pretty straightforward to me:

Dim1: Day x-val

Dim2: Amount y-val

Expression: count(Amount y-val)

---------

I correct myself, it is not as straightforward to implement in QlikSense as I thought - apologies for this. I managed to create something very close to it using an aggregated dimension utilizing the aggr() function.

QS_ScatterPlot_Sample.JPG

brunobertels
Valued Contributor

Re: Distinct aggregate function?

Hi

Does something like that will help you :

you need to download the grid chart extension available on qlikbranch

attached sample app with your data

Regards

Bruno

reddys310
Honored Contributor II

Re: Distinct aggregate function?

Hi Scot,

The scatter plot in QlikSense needs atleast 2 measures and the 3rd measure shows the size of the bubble. As there are only 3 fields in totally this cannot be achieved using the implicit scatter plot. Instead you can achieve this using an extension as Bruno mentioned.

Make use of this expression to calculate  the frequency.

aggr(count(Amountyval),Dayxval,Amountyval)

Thanks and Regards,

Sangram Reddy.

Not applicable

Re: Distinct aggregate function?

Thanks for your prompt replies. 

It is becoming apparent to me that extensions are an important part of the Qlik universe.  I will be able to check out the grid extension shortly.

Just wanted to let you know I saw your replies.

Not applicable

Re: Distinct aggregate function?

Ok.  We're getting there.

Grid Extension visually represents the data, but doesn't seem to scroll like the scatter plot.  The "day(x-vals)" values can get up into the 1000s so I need to be able scroll horizontally.  The amount values (y-vals) scale needs to be dynamic to account for various ranges of amount.  Our current Excel visualizations sort the data by "day" and connect each point adjacent point in the scatterplot with a line.  It looks like the following:

grid visualization.png

The yellow is an overlay that we will eventually want to implement.  The green dots are what I need to render in Qlik Sense.  I need the scale on the left and bottom to be consistent.

We will eventually want to be able to put three sets of data on the same graph, turning them on or off.  The excel version is very slow and static.  We want an interactive dynamic capability for analysts.

There are three other visualizations that need to be rendered as well.

Community Browser