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.