Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
vjoshi2017
Contributor
Contributor
‎2018-06-05 07:44 AM

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.

cluster.PNG

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.

customer.PNG

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))

Thanks,

Vivek

2,529 Views
0 Likes
1 Reply