Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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.
Try this instead:
=sum({<[company name] = {"cog*"}>}sales)
What is the use of ? in Qlikview expression?
Sandeep
Go through the HIC blog The Expression Search
you will get clear understanding about search perform in QV.
Thanks
BKC
Hi,
? represent one character and
* represent all
Regards