Display Quarter/Year on Expression Axis Gantt Chart
I have a simple gantt chart for which I'm trying to display, for example, Q1/2016 instead of '01/XX/16'. Is there anyway to do this? I've tried using DUAL but I'm guessing because this is the result of the expression it will always display the numeric side.
Another issue is when defining the static step as 90, it adds a 5th 'quarter' to 2019. I believe this is due to not all quarters having 90 days and eventually the static step does not land in January. I've tried various numbers but all throw off the axis, even when defining static min/max.
If I take Qlik's default step increment it will show every other quarter (1st and 3rd) correctly, but am missing 2nd/4th even if I enlarge the chart's size.
I would prefer to use reference lines as a last resort. I've attached sample app.
