Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
yoganantha321
Contributor II

Expression required for Gantt chart

I have a column named Actual dates which consists of all the dates from 01-01-2018 to 31-12-2018.

I have some employees planned for travel or vacation for some days. So i have 2 columns named startname and endname.

i want to show in a gantt chart.

I have done an expression which is representing the travel or vacation in two different colors but i need the remaining dates to be filled with third color.

i attached the image with blue and orange is the actual output as shown in vacation_actual.png i am getting. but i need the remaining dates must be filled with red color as shown vacation_expected.png.

vacation_actual.PNGvacation_actual
vacation_expected.pngvacation_expected

I have attached a sample file along with this.

Anybody help in this!!!!!

Regards,

Yoganantha Prakash G P

Tags (2)
1 Reply
yoganantha321
Contributor II

Re: Expression required for Gantt chart

Anybody can help in this!