Summing up values from a large UNION query containing sums/groups by's...

[#1]

Hi all,

I have a large union query containing 5 union elements.

Each one performs a sum and group by from the same SQL server database.

I then need to sum up the result of the UNINO statements.

Now, i'm not sure whether to do this in QlikView script (in which case how do I perform a sum in the LOAD and add a group by at the bottom, when all of the queries have group by's already)

or.. whether to wrap this UNION query into a main query that sums the UNION results - if that makes sense?

answers on a postcard.....

thanks in advance,

Matt