Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I have the following data set:
Weeks | Sales | Hours | Productivity |
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.
Is there a way to get the trend of all three measures clearly?
Sort of like this:
Thanks to everyone who can help.
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.