Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Skip the ticket, Chat with Qlik Support instead for instant assistance.
Showing results for 
Search instead for 
Did you mean: 

How to create average reference lines in scatter plot on different levels of hierarchy?

I have two dimensions,

clusters and customers

Cluster is a set of customers.

I am using an scatter plot and reference lines to create 4 quadrants.


If I go inside any cluster, I want to see the same reference line for that levels. For example, if I select cluster 7, my plot should be like below.


Is there a way to do that? In this case, I did it manually to show what I want.

Formulae used for averages :

On cluster level := sum(ActualSalesValue)/count(distinct Behavioural_Class)

On customer Level:= sum(ActualSalesValue)/count(distinct Customer)

I tried to use dimensionality but I don't get a value greater than 0 in any case.

Below is what I tried and is not giving me results.

=if (Dimensionality() > 0,  sum(ActualSalesValue)/count(distinct Behavioural_Class), sum(ActualSalesValue)/count(distinct Customer))



1 Reply