QlikView - Functions



QlikView has many built-in functions, which are available to be applied to data that is already available in memory. These functions are organized into many categories and the syntax of the function appears as soon as it is selected. We can click on the Paste button to get the expression into the editor and supply the arguments.

Create Table Box

Create a Table Box by following the menu as shown in the screen shot given below.

table_box_option

On completing the above given step, we get a window to show the Calculation condition at the bottom left.

3_functions_calculation_fields.

List of Functions

Click on the button next to calculation condition and go to the Function tab. It shows the list of functions available.

4_functions_all_functions

On choosing String from the functions category, we can see only few functions, which take a string as an argument.

5_functions_string

In the next chapters, we will see the use of many important functions.

Advertisements