topic Combining events into event keys and adding sums, respectively in QlikView

Combining events into event keys and adding sums, respectively

Thu, 18 Sep 2014 18:30:03 GMT

Hi,

I want to take this :

And make it so each eventtitle is paired with another eventtitle in a key pairing, for example Annual Meeting 2012-Annual Meeting 2013.

I want to do every combination of the event column with the other events (Annual Meeting 2012-Nurse Manager Fellow's; Annual Meeting 2012-From Worst to First... etc.) and I want to add up the sumregistration column for each event (so Annual Meeting 2012-Nurse Manager Fellow's sum(sumregistration) = 8300) if that makes sense.

Thank you!

Re: Combining events into event keys and adding sums, respectively

maxgro — Thu, 18 Sep 2014 19:14:03 GMT

.....and I would like your test data to try

some ideas (pairing, every combination, ....) in the attachment

Re: Combining events into event keys and adding sums, respectively

Thu, 18 Sep 2014 19:46:33 GMT

I actually just figured it out. I made a mapping load out of the first table I put up then I found the distinct eventkey from a previous table I had after that I did a map substring load:

RegSumGraph:

mapping load

EVENTTITLE as Event1,

SUMREGISTRATIONPRICE as sumreg

Resident DistinctSum;

CombineSum:

load

MapSubString('RegSumGraph',EventTemp1) as sum1,

MapSubString('RegSumGraph',EventTemp2) as sum2,

EventKey

It's probably confusing considering you didn't see the data but I hope that clear it up a bit! Thanks anyway!

Joe