Sum from a different table

Fri, 18 Oct 2013 07:30:27 GMT

name	ticket_number	quantity	date
ruth	96	15	2013-10-18
alisa	96	20	2013-10-18
megan	54	5	2013-10-19
ruth	10	2	2013-10-19

I have done this easily on mysql (Select sum(quantity) from buyer where ticket_number=winner_table.winner_number) but is giving me a hell here because I'm somewhat new.

date	first_place_ticket	second_place_ticket	third_place_ticket
2013-10-18	96	25	75
2013-10-19	54	54	74

What Im trying to do:

I need to sum the quantities of winner tickets given a date and store it on a field and/or variable, for example (on the day 18 they were a total of 35 tickets of the number 96, 0 of 25 and 0 of 75.

So I can get something like:

date	first_winner_quantity	second_winner_quantity	third_winner_quantity
2013-10-18	35	0	0

What I've already tried:

A user of this forum gave me a great solution (THANK YOU AGAIN)....It was a straight table but sadly when a try to implement it to my problem I just sum the quantity of ALL the tickets from that day instead of the winner one only.

I'll attach the customers.csv, winner_tickets.csv and .qvw file with the example I got from here (INLINE) and my failure attempt to emulate that.

I've weeks trying to accomplish this by my own please help me

Re: Sum from a different table

Fri, 18 Oct 2013 08:18:29 GMT

Hi Richard,

Please find attached.

regards,

GowriShankar

Re: Sum from a different table

Fri, 18 Oct 2013 18:18:50 GMT

I have no words to describe my gratitude to you.

Thank you very much

topic Sum from a different table in QlikView

Sum from a different table

Re: Sum from a different table

Re: Sum from a different table