Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
a5123283
New Contributor II

Gantt chart help with quarter date axis conversion

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

gantt  chart.jpg

Thanks in advance,

Nelson

Community Browser