Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
How do we use Having clause (SQL Equivalent) along with Groupby in QlikView?
Thanks in Advance.
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