Display line graph with two different tables Data

[berryandcherry6]

Hi,

i have two tables like below

LOAD delivered,

email_type_id as email_metric_type_id,

date(floor(date_created),'MM-DD-YYYY') as emaildatecreated;  //date is not continues

SQL SELECT delivered,

email_type_id,

date_created

FROM EMAILMETRICS;

LOAD

Date(Date#(Date,'YYYYMMDD'),'DD-MM-YYYY') as [Format Date],  //date is continues till date

    TotalHits;

SQL SELECT

    Date,

    TotalHits

FROM TrafficView;

Here in EMAILMETRICS, emaildatecreated is not continuos. [Format Date] is continuos. Now i need to put single  line graph for delivered and TotalHits for last 6 months. How could i do this?

[sarvesh]

Please refer below mentioned link:

Line chart, 2 dimensions, 2 expressions

[berryandcherry6]

Date should not repeat, it has to be each date has to be  only once. But given link shows date repaeted in x-axis

[sarvesh]

If multiple data is available on single date then it will be reflect in your report.

[berryandcherry6]

That is my question, on how to do it if i have multiple data for single date

[sarvesh]

Please read the properties of charts from below mention link, i think it will helpful for you.

https://help.qlik.com/en-US/sense/3.2/Subsystems/Hub/Content/Visualizations/LineChart/line-chart-pro...