Loading Excel data into QlikView | Qlik Community

[raviityou]

Loading Excel data into QlikView | Qlik Community

Is it possible to use Where & Having clause Group by 

Shared with Jive Anywhere

http://community.qlik.com/thread/2926

[jonathandienst]

Hi

Its certainly possible to use a Where clause. I am not sure about Group By and Having clauses, but I have my doubts. Why don't you test it for yourself, it is easy enough to do so.

HTH

Jonathan

[#3]

Hi,

I am not sure about group by and Having clause,if you want to use for group by and having using of resident load

Tab:

Load a,

        b

from a.xls;

like this

Tab1:

Load count(a),

        b

resident Tab group by b having count(a)>10;