filter the data

[ravindraa]

Hi Exprerts,

I have one urgent requirement please help me on this. I have two fields one WAVE  and DISTRICT fields

wave	District
wave1	prakasam
wave1	guntur
wave1	Eastgodavari
wave1	westgodavari
wave2	prakasam
wave2	guntur
wave2	Eastgodavari

Expected result :

wave	District
wave1	prakasam
wave1	guntur
wave1	westgodavari
wave2	prakasam
wave2	guntur
wave2	Eastgodavari

here i have to filter the Eastgodavari district data from Wave1 which is also available in wave 2. That means we don't want wave1 data from Eastgodavari district

please give me any suggesion.

thanks for advance.................................

[Anil_Babu_Samineni]

Expected result?

[ravindraa]

Hi Anil Babu,

thanks for reply  below are the expected reslult.

wave	District
wave1	prakasam
wave1	guntur
wave1	westgodavari
wave2	prakasam
wave2	guntur
wave2	Eastgodavari

[prma7799]

In back end

where wave  <> 'wave1' and District <>'Eastgodavari'

[Anil_Babu_Samineni · Accepted solution]

Why Can't you simply do this? I seriously omit to do this. Could be some reasons I've doing hard code

LOAD wave,

     District

FROM

[https://community.qlik.com/message/1283467]

(html, codepage is 1252, embedded labels, table is @1) Where Not WildMatch(wave, 'wave1') or  Not WildMatch(District, 'Eastgodavari');

[Anil_Babu_Samineni]

And won't work, Should be in OR operator

[prma7799]

PFA..

[ravindraa]

Thanks for giving support Anil Babu........it is working for me thank you very much

.