Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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.