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

Fri, 09 Jul 2010 10:51:48 GMT

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

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

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