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.

After clicking New option

Step 2: Select text object

The next step is select a text object.

text object

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

text

Step 3: Go to properties of text object

The next step is go to properties of text object.

properties

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.

function

Step 5: Now you will see this output.

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

output

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

function1

Step 5: Now you will see this output.

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

output1

Summary

This blog defines how substringcount function works in QlikView.