HAVING Clause In QlikView

 Introduction

The HAVING clause is used with each group of the grouped table. The HAVING clause is used with a single group as an entire result. The HAVING clause is used with aggregate functions. Examles of aggregate functions are SQL SUM function, SQL COUNT function, SQL MIN function and SQL MAX function. The HAVING clause can be used in combination with a GROUP BY clause. The HAVING clause shows only specific conditions. The HAVING clause filters the group results in the final results. The HAVING clause is always used with a GROUP BY clause. The HAVING function returns only rows where aggregate values satisfies specified conditions.

Use of HAVING clause in QlikView application

There are given some basic steps to understand the concept of a HAVING clause in QlikView.

Step 1: Open the QlikView application: It is the first step, in this step you need to open the QlikView application then go to
File-> New then this window will be opened.



Step 2: Open Edit Script: The second step is open the edit script window from File-> Edit Script.



Step 3: Select Database: The third step is to select a database from the Data tab and click on the Connect Button.



Step 4: Data link property window: In this window we select a SQL Server and click on the "Next" Button.



Step 5: Connection tab: In the connection tab, you entered the server name and user name and password and select the database from your server and click on Test Connection.

 

• Then you find that the test connection has succeeded and click on the OK button.
  
  
   
• Then click on the OK button.
  
  
  

Step 6: SQL Server login: Then they require a SQL Server login so you have entered a valid Login ID and Password and click on the OK button.



Step 7: Create select statement: When we click on the Select button in the Data tab then this window will be opened.

• Then this window will be opened and click on the OK button.
  
  
  
  
• This window will be open-
  
  
  

Step 8: Code of edit script: After login into the SQL Server, the edit script window will be opened and reload it.



Step 9: Save QlikView file: After reload the edit script, the next step is save the QlikView file and click on the Save button.



Step 10: Script execution progress: Then the Script Execution progress window will be opened and require a Login Id and Password and click on the OK button.



Step 11: Sheet property Window: After this process, the sheet property window will be opened. If you want to add a field and select a field from an available field and click on the OK button.

• Then this window will be opened.
  
  
  

Step 12: Select Table box: Now right-click anywhere in the blank main sheet and select New Sheet Object-> Chart, then the window will be opened.



Step 13: General Window: In this window we select Add All to select all fields in the table and click on the OK button.



Step 14: Main Window: Now look at this window and again open an Edit script.



Step 15: Use of HAVING clause: Now we write the code of a HAVING clause and reload it.



Step 16: Script execution progress: Then the Script Execution progress window will be opened and require a Login Id and Password and click on the OK button.

 

Step 17: Final window: Now this window will show how the HAVING clause works.



Summary

This article provided the basic concepts of a HAVING clause and also described the HAVING clause works in QlikView.