topic Re: remove data from a field in QlikView

remove data from a field

Thu, 14 May 2015 17:19:49 GMT

Hi,

I'm new in QV and I can´t figure out how to remove data from a field..

My table is like this:

Product Cost

A1 5

A2 4

A3 3

B 5

C 2

Basically I want to eliminate all the values on my fields "Product and Cost" that start with Product = A.

I guess is some kind of If o a function that removes a row..

Thank youuuuu

Anonymous — Thu, 14 May 2015 17:22:53 GMT

If it is from file:

LOAD

Product,

Cost

FROM ...

where left(Product,1) <> 'A';

(There are other ways of course.)

Thu, 14 May 2015 17:28:27 GMT

works prefectly!!!

Clever_Anjos — Thu, 14 May 2015 17:46:27 GMT

LOAD

Product,

Cost

FROM ...

where Product not like 'A*';

Anonymous — Thu, 14 May 2015 17:50:15 GMT

I was wondering why so few answers

OK, one more:

...

where wildmatch(Product,'A*')=0;

Clever_Anjos — Thu, 14 May 2015 18:13:52 GMT

where not wildmatch(Product,'A*');

Anonymous — Thu, 14 May 2015 18:22:55 GMT

Now we have a good number of solutions

Thu, 14 May 2015 18:24:39 GMT

Lol yeah, I'll be a QlikView expert in removing data from fields soon haha