Qlik: Combining two plots with different date format

raginipaul24 — Sat, 26 Dec 2020 05:21:34 GMT

Hi All!

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?

Thanks for any advice!

Re: Qlik: Combining two plots with different date format

rubenmarin — Sun, 27 Dec 2020 10:49:55 GMT

Hi @raginipaul24, if possible (and makes sense) I would try to concatenate both series in an unique fact table.

Also load the dates as numbers and relate this field of the fact table with a calendar table that has a single date format, if this is confusing, just using the same date format for both facts.

topic Qlik: Combining two plots with different date format in QlikView

Qlik: Combining two plots with different date format

Re: Qlik: Combining two plots with different date format