Substringcount Function in QlikView

This blog defines what is substringcount function .

In this blog, I explain what is Substringcount function in QlikView.

What is Substringcount function?

SubStringCount  function counts the substrings under the string.

Syntax

num SubStringCount (text, sub_string)

Below is the steps to create substringcount function in QlikView.

Step 1: Open the QlikView application

In the first step you need to open the QlikView application then go to File -> New then this window will be opened.

Step 2: Select text object

The next step is select a text object.



After that you will see text object. According to your own choice you can change color of text object.



Step 3: Go to properties of text object

The next step is go to properties of text object.



Step 4: Now you will see text box property window. Here you have to define substring count function.

Example

Here I give any string to count substring of this string. In this string I found how many 'a' are available in this string.



Step 5: Now you will see this output.

The text object shows '4'. It means that only '4' 'a' are available in my string.



Step 6: If you want to know how many delimiter in your string. Then simply pass delimiter in substringcount function.



Step 5: Now you will see this output.

The text object shows '1'. It means that only '1' ',' is available in my string.



Summary

This blog defines how substringcount function works in QlikView.