Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Combining events into event keys and adding sums, respectively

Hi,

I want to take this :

1.png

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!

2 Replies
Highlighted
MVP
MVP

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

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

Not applicable

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