SQL to QV

[#1]

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

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

Thanks 😃

[Anonymous · Accepted solution]

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