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

[#1]

Hi All,

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

Thanks in Advance.

[maxgro]

maybe with a preceding load

SQL : select f1, sum(e) from table group by f1 having sum(e) > 100

QLIK:

TEST:

load * inline [

f1, e

a,1

a,1

a,1

b,1

c,1

d,100

d,500

e,10

e,2

f,200

];

FINAL:

load * where sume> 100;

load f1, sum(e) as sume Resident TEST group by f1;

DROP Table TEST;

You can also write your sql with the having clause in Qlik, without any change