Summing up values from a large UNION query containing sums/groups by's...
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?
