Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Expression excluding what contains "x"

Hello

I know how to exclude ítems that it is ok and works

sum({$<[Color]={'*'}-{'Red','Blue'}>}

But if i want to exclude for example the ones that contains a "e". I do not know why this formula is not working in the expression.

Anybody knos why or another way to do it

sum({$<[Color]={'*'}-wildmatch(Color,'*e*')>}

Thanks

Belén

1 Solution

Accepted Solutions
luciancotea
Valued Contributor

Re: Expression excluding what contains "x"

sum({$<[Color]={"*"}-{"*e*"}>} ...

4 Replies
luciancotea
Valued Contributor

Re: Expression excluding what contains "x"

sum({$<[Color]={"*"}-{"*e*"}>} ...

mukesh24
Contributor III

Re: Expression excluding what contains "x"

Hi u can use following:-

sum({<[Color]={"*"}-{"*e*"}>}

neetha_p
Honored Contributor

Re: Expression excluding what contains "x"

Hi

Try

sum({$<[Color] -={'*e*')>} .....

-= is equavalent of not equal to sign

praveenak
New Contributor II

Re: Expression excluding what contains "x"

Hi

Use

sum({<[Color]={'*'}>-<[Color]={'*e*'}>})

Community Browser