Peek.dll, File description: PEEK Driver API (ASCII and UNICODE) Errors related to peek.dll can arise for a few different different reasons. For instance, a faulty application, peek.dll has been deleted or misplaced, corrupted by malicious software present on your PC or a damaged Windows registry. The Peek method returns an integer value in order to determine whether the end of the file, or another error has occurred. This allows a user to first check if the returned value is -1 before casting it to a Char type. This method overrides TextReader.Peek. The current position of the StreamReader object is not changed by Peek.
.jpg "Peek")
- Qlikview Tutorial
- QlikView Data Loading
- QlikView Report Interface
- QlikView Data Transformation
- QlikView Data Model
File Peeking
- QlikView Data Analysis
- Qlikview Useful Resources
- Selected Reading
The peek() function in QlikView is used to fetch the value of a field from a previous recordand use it in calculations.
Input Data
Let us consider the monthly sales figure as shown below. Save the data with file namemonthly_sales.csv.
Load Script
The above data is loaded to QlikView memory by using the script editor. Open the Script editor from the File menu or press Control+E. Choose the Table Files option from for the file containing the above data. Edit the loadscript to add the following code. Click OK and click Control+R to load the data into QlikView's memory.
Creating Sheet Object
File Peek A Boo
Let us create a Table Box sheet object to show the data generated by the above script. Go to the menu item Layout → New Sheet Object → Table Box. The following window appears in which we mention the Title of the table and select the required fields to be displayed. Clicking OK displays the data from the csv file in the QlikView Table Box as shown below. Also set the sort order as shown below to get the result in the same order of the field Month as it is in the source.
On completing the above steps and clicking Finish, we get the Table box showing the dataas given below.
File Peekskill
Using peek() Function in Calculations
The peek() can be used in calculations involving other columns. Let us display the percentage change for sales volume for each month. The following script achieves this result.
File Descriptor Peek
Creating Sheet Object
Let us create a Table Box sheet object to show the data generated by the above script.Go to the menu item Layout → New Sheet Object → Table Box. The following window appears in which we mention the Title of the table and select the required fields to be displayed. Clicking OK displays the data from the CSV file in the QlikView Table Box as shown below.