Qlik Community

Third-Party Qlik Jobs

Area for people to learn more about current Qlik related job postings.

Not applicable

How do you use Having clause (SQL Equivalent) along with Groupby in QlikView?

Can anyone explain how to you use Having clause (SQL Equivalent) along with Groupby in QlikView?

1 Reply
MVP
MVP

Re: How do you use Having clause (SQL Equivalent) along with Groupby in QlikView?

maybe with a preceding load (having sum(Expression1)>100)

t1:

load * where sumfield > 100;

load TransLineID, TransID, sum(Expression1) as sumfield

from tt.qvd (qvd)

group by  TransLineID, TransID;