Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
qlikuser3
New Contributor III

How to handle the very large scale view across left and right Y axis in the Qlik Sense

Hello All,

Can you please help in explaining the better way to put the graph with a view when we have drastic ranges over multiple y-axis measures

Data

TypesSum(Step1_Step2)Sum(Step2_Step3)Sum(Step3_Ste4)Sum(Criteria_1)Sum(Criteria_2)
Type 138.12.32.2523,714.6
Type 28.40.112.81514,495.0
Type 31.51.712.469353.3
Type 43.50.010.0115261.9
Type 510.42.02.1115,400.9
Type 68.90.16.1342564.0

 

Using this data we wanted to show that Sum(Step1_Step2) Sum(Step2_Step3) Sum(Step3_Ste4) as Stacked bar information and Sum(Criteria_1) as one Y-axis line and Sum(Criteria_2)  as another Y-axis line and problem being the

  1. Sum(Criteria_1) is way smaller compared to Sum(Criteria_2)
  2. Sum of Sum(Step1_Step2) Sum(Step2_Step3) Sum(Step3_Ste4) is way smaller than Sum(Criteria_1) sometimes 

Hence we are not able to fit the Sum(Criteria_1) which is rarely visible proper in the graph and I have attached the graph in the section below, Can you please help me provide a better solution and some kind of hacks where we can solve this problem

 

 

6f052435c95d49649fef71ca082b8411.png

 

3 Replies
Highlighted
Employee
Employee

Re: How to handle the very large scale view across left and right Y axis in the Qlik Sense

Hi Qlikuser3 - I sent this to a few of my colleagues to see what might be the best way to approach this.

Regards,

Mike T

Qlik

Regards,
Mike Tarallo
Qlik
Highlighted
qlikuser3
New Contributor III

Re: How to handle the very large scale view across left and right Y axis in the Qlik Sense

@Michael_Tarallo Thanks for looking into this, Please help us with little urgency on this request !!

Highlighted
Employee
Employee

Re: How to handle the very large scale view across left and right Y axis in the Qlik Sense

Imho, having measures of several orders of magnitude apart is probably not best solved by putting everything in to one chart.

I favor like in this article (https://outlier.ai/data-driven-daily/data-visualization-comparing-multiple-measures-on-the-same-plot...) to reduce to two measures and a dual axis. Another option could be to normalize (if possible) the measures to %.

Thanks,

Patric