SQL to QV

Tue, 02 May 2017 07:49:32 GMT

How to write in script for a graphic this SQL query :

SELECT Max(Sum(Qté receptionnée)) From table GROUP BY Site;

Thanks 😃

Re: SQL to QV

Anonymous — Tue, 02 May 2017 08:17:01 GMT

If you want to get the max of sum(Qté receptionnée) among all the sites, the above sql query will not work i guess.

We cant use a aggr function inside another aggr function.

Your SQL query should be something like SELECT Max(B.A) From (SELECT Sum(Qté receptionnée) as A From table GROUP BY Site)B.

And in qlikview you can use it as

Load max(A) as max;

Load sum(Qté receptionnée) as A

,Site

Resident table / From filename

Group by Site