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 similar expressions from 2->1 bar chart failed to display data

Hello guys.

I have  a list where i select the Dimension (93x107 or 101x110) and i created 2 bar charts with below expressions:

1 chart:  

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

2 chart:   

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

I tried to create one bar  chart with both dimensions . 

When i choose from the list the 2 dimensions together chart can not display  data. If i pick one by one is okay?

Y axis & X axis are the same

Why its happening?

Thank you.

 

 

Labels (1)
4 Replies
deepanshuSh
Creator III
Creator III

What expression are you using for the combined bar chart, that would affect the results that you are getting.

And secondly, the dimension that you are referring here is two values of the same dimension or completely two different dimensions?

Trial and error is the key to get unexpected results.
cmano
Creator
Creator
Author

I want to take the average.

i have this filter (with 3 choices): 

Screenshot 2022-10-01 221211.png

I have the expressions in the same bar chart:

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

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

List box:
Click only on : 93x107  see left image (i get data)

Click  only on : 101x110  see right image (i get data)

Screenshot 2022-10-01 221934.png

List Box
Click both : 93x107 & 101x110

 

No data display...

Screenshot 2022-10-01 221359.png

 Any ideas?

Best regards

RafaelBarrios
Partner - Specialist
Partner - Specialist

Hi @cmano 

i think you are not doing it in the correct way.

what you are using as expression only going to works if you select a dimension value.

so,  what i think to need is the following:

use the field "Dimension" as dimension of the chart and as expression

Avg({< WorkCenter_Descr={'Σωλήνες της Πρέσας που προορίζονται για τους Πάγκους 1 & 3'},MeasType={'A'}   >}Dev)

it should show 3 bars, 1 for each dimension value.

OR

if you still want to use different expressions:

Dont set any dimension in the char

expression1

Avg({< WorkCenter_Descr={'Σωλήνες της Πρέσας που προορίζονται για τους Πάγκους 1 & 3'},MeasType={'A'},Dimension= {'93 x 107'}   >}Dev)

expression2

Avg({< WorkCenter_Descr={'Σωλήνες της Πρέσας που προορίζονται για τους Πάγκους 1 & 3'},MeasType={'A'},Dimension= {'113x 122'}   >}Dev)

expression3

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

Best,

cmano
Creator
Creator
Author

Hello @RafaelBarrios that worked thank you.
But they want some additions (target on average, sd & target of sd:
i have create this :

Screenshot 2022-10-03 114135.png

Expressions : 

A

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

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

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

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

M

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

and etc.

But they want something like these:

IMG_20221003_115219.jpg

Able to see for each MeasType (A,M,T) per Dimension is it possible?

thank you