Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

SQL to QV

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

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

Thanks 😃

1 Solution

Accepted Solutions
laddu_927
Specialist
Specialist

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

View solution in original post

1 Reply
laddu_927
Specialist
Specialist

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