Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
cmano
Creator
Creator

Combine data from 3 different charts

Hello guys.

I have 3 dimensions (93 x 107, 101 x 110, 113 x 122 ) on a List Box.

Each dimension have 3 points ( A=Begin, M=Middle, T=End).

I want to create a bar chart with all dimensions and all the points.

At each point i want :

Average
Target on average
Standard Deviation
Target on Standard Deviation.

Target on average & Target on standard deviation are prefixed values that QV reload them from script.

Until now i have create 3 separate bar chart for each value.

Screenshot 2022-10-11 092617.png

Expressions:

 Average A

=If(WorkCenter_Descr='Σωλήνες της Πρέσας που προορίζονται για τους Πάγκους 1 & 3' and Dimension= '101 x 110' and MeasType='A' ,Avg(Dev))

Target on Average A

=If(WorkCenter_Descr='Σωλήνες της Πρέσας που προορίζονται για τους Πάγκους 1 & 3' and Dimension= '101 x 110' and MeasType='A' ,TargetYear.Tave)

Standard Deviation A

=If(WorkCenter_Descr='Σωλήνες της Πρέσας που προορίζονται για τους Πάγκους 1 & 3' and Dimension= '101 x 110' and MeasType='A' ,Stdev(Dev))

Target on Standard Deviation A

=If(WorkCenter_Descr='Σωλήνες της Πρέσας που προορίζονται για τους Πάγκους 1 & 3' and Dimension= '101 x 110' and MeasType='A' ,TargetYear.TStnd)

Average M

=If(WorkCenter_Descr='Σωλήνες της Πρέσας που προορίζονται για τους Πάγκους 1 & 3' and Dimension= '101 x 110' and MeasType='M' ,Avg(Dev))

Target on Average M

=If(WorkCenter_Descr='Σωλήνες της Πρέσας που προορίζονται για τους Πάγκους 1 & 3' and Dimension= '101 x 110' and MeasType='M' ,TargetYear.Tave)

Standard Deviation M

=If(WorkCenter_Descr='Σωλήνες της Πρέσας που προορίζονται για τους Πάγκους 1 & 3' and Dimension= '101 x 110' and MeasType='M' ,Stdev(Dev))

Target on Standard Deviation M

=If(WorkCenter_Descr='Σωλήνες της Πρέσας που προορίζονται για τους Πάγκους 1 & 3' and Dimension= '101 x 110' and MeasType='M' ,TargetYear.TStnd)

etc.

Is it possible to combine these 3 to 1 bar chart?

Like the below?

Screenshot 2022-10-11 093517.png

Best reagrds

 

Labels (1)
0 Replies