Skip to main content
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
luca_bellotti
Contributor III
Contributor III

bar chart with three dimesions

Hello everyone,
I have the following data set:

WeeksSalesHoursProductivity
01/01/2018    4.420.000.000,00      26.400.000,00                 167,42  
08/01/2018    4.410.000.000,00      26.400.000,00                 167,05  
15/01/2018    4.405.000.000,00      26.400.000,00                 166,86  
22/01/2018    4.400.000.000,00      26.400.000,00                 166,67  
29/01/2018    4.395.000.000,00      26.400.000,00                 166,48  
05/02/2018    4.390.000.000,00      26.400.000,00                 166,29  
12/02/2018    4.390.000.000,00      26.400.000,00                 166,29  
19/02/2018    4.390.000.000,00      26.400.000,00                 166,29  
26/02/2018    4.385.000.000,00      26.400.000,00                 166,10  
05/03/2018    4.380.000.000,00      26.400.000,00                 165,91  
12/03/2018    4.385.000.000,00      26.400.000,00                 166,10  
19/03/2018    4.390.000.000,00      26.400.000,00                 166,29  
26/03/2018    4.400.000.000,00      26.400.000,00                 166,67  
02/04/2018    4.380.000.000,00      26.350.000,00                 166,22  
09/04/2018    4.360.000.000,00      26.300.000,00                 165,78  
16/04/2018    4.360.000.000,00      26.400.000,00                 165,15  
23/04/2018    4.355.000.000,00      26.400.000,00                 164,96  
30/04/2018    4.355.000.000,00      26.400.000,00                 164,96  
07/05/2018    4.360.000.000,00      26.400.000,00                 165,15  
14/05/2018    4.355.000.000,00      26.400.000,00                 164,96  
21/05/2018    4.355.000.000,00      26.400.000,00                 164,96  
28/05/2018    4.350.000.000,00      26.400.000,00                 164,77  

 

I would like to represent the trend in graphic form using a single chart. The problem is that the three values are very different from each other. I tried to use two Y axis, one with sales and hours and the other with productivity, but the result does not satisfy me.

Cattura.PNG

Is there a way to get the trend of all three measures clearly?

Sort of like this:

Cattura 2.PNG

Thanks to everyone who can help.

Labels (1)
1 Reply
santho_ak
Partner - Creator III
Partner - Creator III

If you are using Qlikview : Stacked & Grouped Bar chart

If you are using Qliksense: Try combo chart & select Bar from properties for all the three values.

 

If you want to show the trend using line chart. Go to properties and change it to Narrow/Wide or use fixed values to represent.