Hello,
I'm trying to display actions in a bar chart in the following way: Number of actions each month from today and 180 days forward. I got a requirement to show month with 0 actions. See chart below (month 1 and month 2 = 0).
![jens231_0-1673344010794.png jens231_0-1673344010794.png](https://community.qlik.com/t5/image/serverpage/image-id/97657i1D98B3D9AA2AD2A8/image-size/medium?v=v2&px=400)
Therefor I use the chart properties "Dimension Axis --> Scale --> Static Min and Static Max."
![jens231_1-1673344226524.png jens231_1-1673344226524.png](https://community.qlik.com/t5/image/serverpage/image-id/97659iC70327E4A147C128/image-size/medium?v=v2&px=400)
For the graph looking forward 180 days it works since im not changing year, only looking in 2023 so far.
But when Im doing the same method for looking back 90 days from today I get a problem.
![jens231_3-1673344426079.png jens231_3-1673344426079.png](https://community.qlik.com/t5/image/serverpage/image-id/97661i474C6953397D4C39/image-size/medium?v=v2&px=400)
![jens231_2-1673344406722.png jens231_2-1673344406722.png](https://community.qlik.com/t5/image/serverpage/image-id/97660i98F8E4C6D6F0B27F/image-size/medium?v=v2&px=400)
Without the static Max I get the following graph:
![jens231_4-1673344483977.png jens231_4-1673344483977.png](https://community.qlik.com/t5/image/serverpage/image-id/97662i1558C449950A1588/image-size/medium?v=v2&px=400)
From what I understand Im not able to get January visable in the second graph since its the first month.
Do you know how I could solve this problem? Im thinking I need a base 12 system --> 1-12 repeating continuously.
Best regards,
J