Data from different tables into one Line chart

[berryandcherry6]

Hi,

i have two tables

LOAD SaleDate,

   Sales ;

SQL SELECT Date,

   Sales

FROM Sales;

LOAD MarketingDate,

   MarketAmount ;

SQL SELECT MarketingDate,

   MarketAmount

FROM Marketing;

i need to display both datas in line chart for Each day without repeating dates, for last 6 months. How could i do this?

[shraddha_g]

Link those 2 tables with dates.

LOAD SaleDate as CalendarDate,

   Sales ;

SQL SELECT Date,

   Sales

FROM Sales;

LOAD MarketingDate as CalendarDate,

   MarketAmount ;

SQL SELECT MarketingDate,

   MarketAmount

FROM Marketing;

and then plot graph

Dimension:- Month(CalendarDate)

Measure 1 :- sum(Sales)

Measure2:- sum(MarketAmount)

[berryandcherry6]

Hi ,

Thanks for reply!

But i need to display for last 6 months that is OCT 2016 to Feb 2017, showing dates in x axis.

[shraddha_g]

Use in Set analysis,

sum({<CalendarDate = {"">=$(=date(addmonths(max(CalendarDate),-6)))}>}MarketAmount)

sum({<CalendarDate = {"">=$(=date(addmonths(max(CalendarDate),-6)))}>}Sales)

In Add Ons section

Uncheck Show Zero Values Property

[berryandcherry6]

Hi Shradda,

Yes, i got what i wanted. But i have a questions here

Instead of Month as a dimension, if i use Dates it shows multiple values for same dates. How could i achieve to get only one value for particular dates without repeatation of Dates?.

[priyasawant]

Hi berryandcherry64‌ kindly rename the date fields of both the table with the same name and then load it so that there is a linking between them and the create a line chart accordingly. Please find the attached images for refrence.

[berryandcherry6]

Hi,

Yes, i have done it. But date gets repeated. Beacuse i sales table, there is multiple values for same date. So combining these two table results in Multiple data.

Please find below attached qvf file,

[priyasawant]

Hi berryandcherry64 kindly change the date format to MonthName(date(DateLink,'MMM-YYYY')) in Dimension then the chart will be as per your requirement