If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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))
Thanks,
Vivek
