topic Re: Sum Multiple data values into single Dimension in QlikView

Sum Multiple data values into single Dimension

berryandcherry6 — Fri, 03 Mar 2017 05:13:21 GMT

Hi,

i have a data where i have multiple data values for a single Date, If i use this data i get multiple values for same data.

But i need it to show Sum of data values to that particular Date.

My data is as below

DateCreated	Sent
01-02-2017	2
01-02-2017	2
01-02-2017	3
02-02-2017	2
03-02-2017	7
04-02-2017	8
04-02-2017	9
04-02-2017	12
12-02-2017	56
01-02-2017	23
20-02-2017	56
19-02-2017	3
13-02-2017	2
17-02-2017	8
18-02-2017	0
19-02-2017	5

But i need to script to produce like this

DateCreated	Sent
01-02-2017	30
02-02-2017	2
03-02-2017	7
04-02-2017	29
12-02-2017	56
13-02-2017	2
17-02-2017	8
18-02-2017	0
19-02-2017	8
20-02-2017	56

I am thinking this way, to display datas in LIne Chart. So that it shows one value to respective date

My Load Script

LOAD Sent,

date(floor(date_created),'MM-DD-YYYY') as DateCreated;

SQL SELECT Sent,

date_created

FROM EMAILMETRICS;

Re: Sum Multiple data values into single Dimension

Anil_Babu_Samineni — Fri, 03 Mar 2017 05:31:22 GMT

Is this?

Re: Sum Multiple data values into single Dimension

berryandcherry6 — Fri, 03 Mar 2017 05:35:51 GMT

Hi Anil,

Thanks for reply!. Yes, it is as in shown graph. I am using Qliksense. can you post script or txt file in here.

Re: Sum Multiple data values into single Dimension

Anil_Babu_Samineni — Fri, 03 Mar 2017 06:09:12 GMT

Even Qliksense it working

I am not sure, Which script you are expecting from my end ?

Re: Sum Multiple data values into single Dimension

berryandcherry6 — Fri, 03 Mar 2017 06:40:42 GMT

Can you please look into this attached sample. Here i am combining two different tables date to display data for last 6 Months. But it shows me repeated date.

Re: Sum Multiple data values into single Dimension

Anil_Babu_Samineni — Fri, 03 Mar 2017 07:10:52 GMT

May be use Join

Source:

LOAD UserTypeTotalView,

Date(Date#(DateTotalView,'YYYYMMDD'),'MM-DD-YYYY') as DateLink,

HitsTotalView,

Year(DateTotalView) AS TrafficYear,

num(Month(DateTotalView), '00') As TrafficMonth_Num ;

SQL SELECT UserTypeTotalView,

DateTotalView,

HitsTotalView

FROM TotalViewTrafficTable;

Join(Source)

LOAD delivered,

campaign_metrics_id ,

sent,

bounced,

opened,

email_type_id as email_metric_type_id,

date(floor(date_created),'MM-DD-YYYY') as DateLink,

date(floor(date_created),'MM-DD-YYYY') as emaildatecreated ;

SQL SELECT delivered,

sent,

campaign_metrics_id,

bounced,

opened,

email_type_id,

date_created

FROM EMAILMETRICS;

Re: Sum Multiple data values into single Dimension

berryandcherry6 — Fri, 03 Mar 2017 08:53:32 GMT

No this is showing multiple data for same date