topic string funtions in QlikView

string funtions

Fri, 12 Sep 2014 16:10:00 GMT

hi QV,

Can any have complete explanation on string Functions with examples .plzzz help me out with this

-lohi

Re: string funtions

JonnyPoole — Fri, 12 Sep 2014 16:13:24 GMT

from the qlikview help select 'index' tab and type: string functions and you'll get the list.

you need to install qlikview Personal edition first.

since its all public , here is a PDF extract from the help of the same

Re: string funtions

Fri, 12 Sep 2014 16:14:07 GMT

Well if you could tell me what you want to do I could sourly help you!

Re: string funtions

don_qlikview — Fri, 12 Sep 2014 16:15:13 GMT

Try this

http://community.qlik.com/blogs/qlikviewdesignblog/2013/03/28/string-functions

http://community.qlik.com/docs/DOC-3971

Re: string funtions

Fri, 12 Sep 2014 16:16:23 GMT

great attachment , thxs is any string functions out of this in Qlik View

Re: string funtions

deepakqlikview_123 — Fri, 12 Sep 2014 16:16:51 GMT

len(string) Returns the length of

a string.

len('QlikView') 8

left(string,

number of

characters)

Starting from the left

of the string, returns

the specified amount

of characters.

left('QlikView', 4) Qlik

right(string,

number of

characters)

Starting from the

right of the string,

returns the specified

amount of characters.

right('QlikView', 4) View

mid(string,

starting

character,

number of

characters

(optional))

Returns a substring

from the string,

starting at the

specified character.

Optionally, the

length of the

substring can be

specified. If no length

is specified, the

right-most part of the

string (starting at the

specified position) is

returned.

mid('QlikView', 5,

mid('QlikView', 5)

View

index(string,

substring,

occurrence

(optional))

Returns the

position at which

the substring is

found in the string.

If an occurrence is

specified, QlikView

will look for that

specific occurrence,

otherwise the

first occurrence

is assumed. If a

negative number

is supplied for

occurrence, QlikView

starts searching from

the end of the string.

If no match is found,

the function returns

index('QlikView',

'i')

index('QlikView',

'i', 2)

index('QlikView',

'i', -1)

upper(string) Converts the string

to upper case.

upper('QlikView') QLIKVIEW

lower(string) Converts the string

to lower case.

lower('QlikView') qlikview

capitalize

(string)

Capitalizes each

word in the string.

capitalize

('QlikView

document')

Qlikview

Document

replace(string,

search string,

replace string)

Replaces the search

string in the string

with the replace

string.

replace('QlikView',

'Qlik', 'Click')

ClickView

mid(string,

starting

character,

number of

characters

(optional))

Returns a substring

from the string,

starting at the

specified character.

Optionally, the

length of the

substring can be

specified. If no length

is specified, the

right-most part of the

string (starting at the

specified position) is

returned.

mid('QlikView', 5,

mid('QlikView', 5)

View

index(string,

substring,

occurrence

(optional))

Returns the

position at which

the substring is

found in the string.

If an occurrence is

specified, QlikView

will look for that

specific occurrence,

otherwise the

first occurrence

is assumed. If a

negative number

is supplied for

occurrence, QlikView

starts searching from

the end of the string.

If no match is found,

the function returns

index('QlikView',

'i')

index('QlikView',

'i', 2)

index('QlikView',

'i', -1)

upper(string) Converts the string

to upper case.

upper('QlikView') QLIKVIEW

lower(string) Converts the string

to lower case.

lower('QlikView') qlikview

capitalize

(string)

Capitalizes each

word in the string.

capitalize

('QlikView

document')

Qlikview

Document

replace(string,

search string,

replace string)

Replaces the search

string in the string

with the replace

string.

replace('QlikView',

'Qlik', 'Click')

ClickView

Re: string funtions

JonnyPoole — Fri, 12 Sep 2014 16:17:46 GMT

yes these are the string functions that qlikview supports.

Re: string funtions

Fri, 12 Sep 2014 16:22:49 GMT

ya sure my requirement is ,

1. we have a variable and field with string .

2.it should check the whole field what we have enter in "Input Box"

3.if that is not there it should show Null if it there it should Compare with Sales or some other fields which we mention in for loop

plz sort me out of this problem

-lohi

Re: string funtions

JonnyPoole — Fri, 12 Sep 2014 16:28:48 GMT

substringcount is 1 way. Just replace your field below where i have fieldname and replace vVariableName with your variable name and 'compare with sales' with the rest of your expression.

if ( substringcount( [FieldName] , $(vVariableName) ) > 0 , ..compare with sales..., null())

Re: string funtions

Fri, 12 Sep 2014 16:41:03 GMT

1. we have a variable and field with string .

2.it should check the whole field what we have enter in "Input Box"

3.if that is not there it should show Null if it there it should Compare with "Sales" or some other fields which we mention in" for loop"

plz sort me out of this problem

-lohi

Re: string funtions

JonnyPoole — Fri, 12 Sep 2014 17:02:57 GMT

It sounds a lot like what a user gets when they type in a search text in a search box against all fields... they will see every data value in every field in the whole data model that matches their typed in value .

Otherwise to check if the inputed string is in ANY of the data values for a given field you can try concat( distinct ) to check. Modified sample as follows...

if ( substringcount( concat( distinct [FieldName] ,';') , $(vVariableName) ) > 0 , ..compare with sales..., null())

for the 'compare with sales' you would need a nested IF statement to select other fields, but that could get slow and inefficient.

Re: string funtions

engishfaque — Sun, 04 Jan 2015 18:12:34 GMT

Dear Lohitha,

Check this thread for list of string functions,

String Functions

Kind regards,

Ishfaque Ahmed