topic How to remove record from the field in QlikView

How to remove record from the field

bhavvibudagam — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

Can any one please help me on this.

TableA:

Load

Data,

ID,

Country,

State

From ....

In the above table Country field contains 5 countries out of 5 countries I have to remove Japan record from country field and from State I have to remove Tokyo record from 5 states.

The filtering need to be done at only field level in the back end script only not at data level.

Please suggest me to proceed.

Thanks in advance.

Re: How to remove record from the field

its_anandrjs — Tue, 05 Dec 2017 16:03:07 GMT

Can you share any sample data.

Re: How to remove record from the field

its_anandrjs — Tue, 05 Dec 2017 16:05:24 GMT

May be this you can

TableA:

Load

Data,

ID,

Country,

State

From ....

Where Not Match(Country,'Japan') and Not Match(State,'Tokyo');

Re: How to remove record from the field

OmarBenSalem — Tue, 05 Dec 2017 16:05:56 GMT

maybe :

TableA:

Load

Data,

ID,

Country,

State

From .... where Country <>'Japan';