Can anyone give example of search a string through expression?

[ananyaghosh]

Hi,

i need to serach a string through an expression like this:-

sum({$<[company name] = {*cognizant?}>}sales) ...so is it valid?

Can anyone give me a reference that for searching a string what is the use of * and ?

and if I want to search a company whose name start with cognizant, then how it will be written?

also is it work like this:

like '%cognizant' for general SQL statement?

[PrashantSangle]

Hi,

try like

count(if(Wildmatch([Comapny Name],'*Cognizant*'),Sales))

IF you want case sensitive search use match()

IF you want non case sensitive search use wildmatch()

Regards

[oknotsen]

Set Analysis statement for string with "cognizant" somewhere in the string:

sum({$<[company name] = {*cognizant*}>}sales)

Set Analysis statement for string with "cognizant" at the start of the string:

sum({$<[company name] = {cognizant*}>}sales)

QlikView script uses the * as wildcard.

The % symbol is used in some databases as wildcard, but not in QlikView.

[awhitfield]

Try this instead:

=sum({<[company name] = {"cog*"}>}sales)

[ananyaghosh]

What is the use of ? in Qlikview expression?

[Anonymous]

Sandeep

Go through the HIC blog The Expression Search

you will get clear understanding about search perform in QV.

Thanks

BKC

[PrashantSangle]

Hi,

? represent one character and

* represent all

Regards

[sagarkharpude]

sum({$<[company name] = {'cognizant*'}>}sales)

Also refer the below link:

The Search String