Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

krithikarees
New Contributor

Remove rows that contain "C0"?

Hello,

I am trying to figure out how to remove all rows of customer number that starts with "C0". Where customer Number is my Key Joining field with other tables.

I need them gone

1 Solution

Accepted Solutions
qv_testing
Valued Contributor

Re: Remove rows that contain "C0"?

Try this,

=IF(wildmatch(CURRENCY,'*CO')<>1, CURRENCY)

7 Replies
isingh30
Contributor III

Re: Remove rows that contain "C0"?

You need solution at script level or UI level?

jwjackso
Contributor III

Re: Remove rows that contain "C0"?

In the where clause try Mid(Text([Customer Number]),1,1) <> 'C'

sureshqv
Esteemed Contributor III

Re: Remove rows that contain "C0"?

try this

Load*

from table where wildmatch(Field,'*c*')<>1

krithikarees
New Contributor

Re: Remove rows that contain "C0"?

UI level would be great.

Thanks

omarbensalem
Esteemed Contributor

Re: Remove rows that contain "C0"?

in your measure:

do as follow:

sum({<CustomerNumber=-{"CO*"}>}YourMeasure)

sureshqv
Esteemed Contributor III

Re: Remove rows that contain "C0"?

try this

add in UI:

=count({<CusstNum-={"CO *"}>} Number)

qv_testing
Valued Contributor

Re: Remove rows that contain "C0"?

Try this,

=IF(wildmatch(CURRENCY,'*CO')<>1, CURRENCY)