topic Re: Sum for entire month in QlikView

Sum for entire month

mgdotcom — Wed, 06 Dec 2017 09:16:34 GMT

I hope someone can help. I need to calculate a sum of target for the entire month selected.

This is my load of the target table

Targets:

LOAD targetID,

clientID,

super_categoryID,

ext_campaignname,

target,

Date(workingday,'YYYY/MM/DD')as Date

And my calendar

Calendar:

LOAD Date(Date,'YYYY/MM/DD') as Date,

Re: Sum for entire month

Anil_Babu_Samineni — Wed, 06 Dec 2017 09:22:15 GMT

Not sure, I followed you. can you explain little in clear

Re: Sum for entire month

mgdotcom — Wed, 06 Dec 2017 09:25:50 GMT

Sorry. So target is a numerical value.

I'm currently doing this is a chart to calculate the daily target based on a selection of year, month and date.

Sum(Aggr(Sum(target),clientID,super_categoryID))

What I would like to do is do a calculation for the entire month. So it shows a monthly Target.

Re: Sum for entire month

Anil_Babu_Samineni — Wed, 06 Dec 2017 09:27:38 GMT

Like this?

Sum(Aggr(Sum(TOTAL <Month> target),clientID,super_categoryID))

Re: Sum for entire month

its_anandrjs — Wed, 06 Dec 2017 09:27:39 GMT

Do you have Month field in your Calendar table if not add this ways

Targets:

LOAD

targetID,

clientID,

super_categoryID,

ext_campaignname,

target,

Date(workingday,'YYYY/MM/DD')as Date

Calendar:

LOAD Date(Date,'YYYY/MM/DD') as Date,

Month(Date,'YYYY/MM/DD') as Month

And on UI part

Dim:- Month (And selected Month)

Expre:- =Sum(target)

Re: Sum for entire month

mgdotcom — Wed, 06 Dec 2017 09:41:37 GMT

This is what i get when I use Sum(Aggr(Sum(TOTAL<Month> target),clientID,super_categoryID))

Re: Sum for entire month

Anil_Babu_Samineni — Wed, 06 Dec 2017 09:43:55 GMT

Have you considering Month as fieldName?

Re: Sum for entire month

mgdotcom — Wed, 06 Dec 2017 10:11:11 GMT

I have a month field in calendar. Would i need one in target also?

Re: Sum for entire month

Anil_Babu_Samineni — Wed, 06 Dec 2017 10:16:05 GMT

Would you mine, Can you provide sample data set and result set?