Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
new020
Partner - Contributor
Partner - Contributor

bar chart limits and custom axis

Hello, 

 

I have a bar chart (instead of bars i use bubbles) and i want to custom the axis. I don´t want the min for the x-axis to forced to 0, i need to forced to the min value of the bubbles shown. 

And i need the same with the max of the axis.

without limits.png

But when i write the expresion in the limits, the bubbles disappear and i don´t know why.

with limits.png

The expresion in Min is:

=RangeMin(min(
{<Month={"$(vMesultimo)"}>}PayingCustomer),
min({<Month={"$(vMesultimo)"}>}DealerGroup_PayingCustomer),
min({<Month={"$(vMesultimo)"}>}District_PayingCustomer),
min({<Month={"$(vMesultimo)"}>}Owner_PayingCustomer),
min({<Month={"$(vMesultimo)"}>}National_PayingCustomer),
min(
AGGR(sum({<Month={"$(vMesultimo)"}>}top25_cust_pay_Sum_PayingCustomer_12),level)
/AGGR(sum({<Month={"$(vMesultimo)"}>}top25_cust_pay_Sum_Active_Customer_total),level)))

 

Please, what i´m doing wrong?

 

Thanks in advance

Labels (2)
0 Replies