topic Re: Sum Distinct in QlikView

Sum Distinct

Thu, 02 Jul 2015 15:33:02 GMT

Hi,

I want to make a sum distinct of some values but I can't get right the statement. My table is like this:

Name Course Lesson Duration +other columns related to lesson

A Z 1 5

A Z 2 5

A Z 3 5

A Y 1 5

B Z 1 5

B W 1 3

I want to know the total duration of all the courses per Name, if I just sum the duration in the case of A for example it will tell me (5+5+5+5) but I only want (5+5) which corresponds to course A and Y. If I just put Sum distinct of duration in the case o A it gives me 5 and doesn't considerate both courses.

I want the following output:

Name TotalDuration

A 10

B 8

I wonder I have to make some magic on the script. I'm attaching the file. Thanks for your help

Re: Sum Distinct

MK_QSL — Thu, 02 Jul 2015 15:35:56 GMT

but I only want (5+5) which corresponds to course A and Y

Y is course???

Please clarify !

Re: Sum Distinct

Anonymous — Thu, 02 Jul 2015 15:37:36 GMT

Does that mean you only wish to sum() where Lesson = 1 ?

Re: Sum Distinct

Thu, 02 Jul 2015 15:38:05 GMT

Sorry, it was "which corresponds to course Z* and Y"

Thanks

Re: Sum Distinct

stigchel — Thu, 02 Jul 2015 15:38:36 GMT

You can use

=Sum(Aggr(sum(DISTINCT Duration),Nombre,Course))

Re: Sum Distinct

ramoncova06 — Thu, 02 Jul 2015 15:38:54 GMT

this should work

sum(Aggr(sum(DISTINCT Duration),Course,Nombre))

Re: Sum Distinct

Gysbert_Wassenaar — Thu, 02 Jul 2015 15:39:59 GMT

Try: sum(aggr(max(Duration),Name,Course))

Re: Sum Distinct

Anonymous — Thu, 02 Jul 2015 15:42:19 GMT

Hi,

try with expression:

=sum(aggr(DISTINCT Duration, Nombre, Course))

Regards.

Re: Sum Distinct

Thu, 02 Jul 2015 15:42:32 GMT

Thank you!!! Apparently it was an easy question. My apologies, I'm new in QlikView