Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

edit expression

These work buy them selves,  but when I try to combine them both not so good.   Shows nothing

=if(Key like 'MTS-E2-MTS',PackBy)and

if(Key like '-E2-MTS',PackBy)

1 Solution

Accepted Solutions

Re: edit expression

May be this

=If(WildMatch(Key, 'MTS-E2-MTS', '-E2-MTS'), PackBy)

or

=If(Key LIKE 'MTS-E2-MTS' or Key LIKE '-E2-MTS', PackBy)

1 Reply

Re: edit expression

May be this

=If(WildMatch(Key, 'MTS-E2-MTS', '-E2-MTS'), PackBy)

or

=If(Key LIKE 'MTS-E2-MTS' or Key LIKE '-E2-MTS', PackBy)

Community Browser