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

Fri, 04 Dec 2015 16:04:04 GMT

Hi All,

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

Thanks in Advance.

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

maxgro — Fri, 04 Dec 2015 18:30:05 GMT

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

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