topic Re: Data from different tables into one Line chart in QlikView

Data from different tables into one Line chart

berryandcherry6 — Mon, 06 Mar 2017 06:14:25 GMT

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?

Re: Data from different tables into one Line chart

shraddha_g — Mon, 06 Mar 2017 06:28:12 GMT

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)

Re: Data from different tables into one Line chart

berryandcherry6 — Mon, 06 Mar 2017 06:36:24 GMT

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.

Re: Data from different tables into one Line chart

shraddha_g — Mon, 06 Mar 2017 07:48:06 GMT

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

Re: Data from different tables into one Line chart

berryandcherry6 — Mon, 06 Mar 2017 08:41:19 GMT

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?.

Re: Data from different tables into one Line chart

priyasawant — Mon, 06 Mar 2017 09:02:10 GMT

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.

Re: Data from different tables into one Line chart

berryandcherry6 — Mon, 06 Mar 2017 09:12:23 GMT

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,

Re: Data from different tables into one Line chart

priyasawant — Thu, 09 Mar 2017 06:40:00 GMT

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