How can we use Having clause (SQL Equivalent) along with Groupby in QlikView?

[nikhilgarg]

Hey,

How can we use Having clause (SQL Equivalent) along with Groupby in QlikView?

Thanks

[sunny_talwar]

I think you should be able to use Where Statement.

[jonathandienst]

You may need a preceding load or a two step load to perform a HAVING equivalent.

For example: SQL

SELECT ID, Sum(Amount) As SumAmount

FROM Table1

GROUP BY ID

Having Sum(Amount) > 0

Qlikview

LOAD ID, SumAmount

Where SumAmount > 0

;

LOAD ID, Sum(Amount) As SumAmount

FROM Table1.xlsx

GROUP BY ID;

[nikhilgarg]

Hey,

but where isn't equivalent to having because we can use where groupby having in sql. So, is it exists() ?

[sunny_talwar]

I guess not entirely sure how it works in SQL. So go with jonathan‌ suggestion

Best,

Sunny