Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to write in script for a graphic this SQL query :
SELECT Max(Sum(Qté receptionnée)) From table GROUP BY Site;
Thanks 😃
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
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