Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am not able to retrieve the number of occurrences of a particular string from a column in qlikview.
can anyone suggest a solution?
use substringcount() function...
syntax: substringcount(Field_Name,'string')
ex: SubStringCount('abcdefabcghi','abc') will return 2, because 'abc' presents times in the given string