Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
raviityou
Partner - Creator
Partner - Creator

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
2 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable

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;