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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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