topic Re: Loading Excel data into QlikView | Qlik Community in QlikView

Loading Excel data into QlikView | Qlik Community

raviityou — Tue, 14 Oct 2014 19:40:33 GMT

Loading Excel data into QlikView | Qlik Community

Is it possible to use Where & Having clause Group by

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

Re: Loading Excel data into QlikView | Qlik Community

jonathandienst — Wed, 15 Oct 2014 06:03:28 GMT

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

Re: Loading Excel data into QlikView | Qlik Community

Wed, 15 Oct 2014 06:55:10 GMT

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,

from a.xls;

like this

Tab1:

Load count(a),

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