Gantt chart help with quarter date axis conversion

Anonymous — Mon, 26 Oct 2015 09:23:29 GMT

Dear all fellow QV peers,

I wish to convert my date axis in my grantt chart from MMM-YY to quarter naming convention. (Q1-2016, Q2-2016 etc...)

Under normal circumstance, this can done in scripting level if date is used as one-dimensional. However, aggregation is used to for calculate duration which makes the situation alittle complicated.

I have tried to use the following solutions but had failed to achieve any results:

1. Define the following in script level but was unable to perform aggregation

'Q' & Ceil(Month(Start)/3) as QUARTER_START,

'Q' & Ceil(Month(End)/3) as QUARTER_END

2. Change date format pattern in 'number' tab

Thanks in advance,

Nelson

topic Gantt chart help with quarter date axis conversion in QlikView

Gantt chart help with quarter date axis conversion