Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Handling multiple dates in X axis Time dimension

Hello all,

I would like to create this bar chart:

Help.PNG

But my datatable is this way:

Help1.PNG

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 !

1 Reply
sunny_talwar

Look into this thread:

Canonical Date