Handling multiple dates in X axis Time dimension

Wed, 14 Sep 2016 15:00:31 GMT

Hello all,

I would like to create this bar chart:

But my datatable is this way:

How can I create a Time dimension that is related to DATE_ALERT_CREATED and DATE_ALERT_COMPLETED at the same time as I want to show the created and completed alerts in the same graph on the same Time dimension.

I had initially created a Time dimension this way but I know it is wrong:

NEW_DATE:

LOAD

DATE_ALERT_CREATED,

Year(DATE_ALERT_CREATED) as Year,

Month(DATE_ALERT_CREATED) as Month,

Date(MakeDate(Year(DATE_ALERT_CREATED), Month(DATE_ALERT_CREATED)), 'MM-YYYY') as Date_New

Resident ALERT_TABLE;

I hope I was clear enough, looking forward to your help ! Thank you !

Re: Handling multiple dates in X axis Time dimension

sunny_talwar — Wed, 14 Sep 2016 15:35:10 GMT

Look into this thread:

Canonical Date

topic Re: Handling multiple dates in X axis Time dimension in QlikView

Handling multiple dates in X axis Time dimension

Re: Handling multiple dates in X axis Time dimension