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

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

nikhilgarg — Tue, 08 Sep 2015 08:03:11 GMT

Hey,

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

Thanks

sunny_talwar — Tue, 08 Sep 2015 08:07:42 GMT

I think you should be able to use Where Statement.

jonathandienst — Tue, 08 Sep 2015 08:09:33 GMT

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 — Tue, 08 Sep 2015 08:12:10 GMT

Hey,

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

sunny_talwar — Tue, 08 Sep 2015 08:14:14 GMT

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

Best,

Sunny