Qlik: Combining two plots with different date format
I am looking to do a line chart in Qlik (online) to plot two data series (both are a date list and a corresponding values list). The data series are in separate tables in the Qlik data manager. The date format is also different (DD.MM.YYYY and YYYY-MM-DD) - how do you recommend I proceed to plot them both onto the same plot?
Should I convert them into the same date format, or combine the two sets into one table?