topic Re: filter the data in QlikView

filter the data

ravindraa — Thu, 08 Jun 2017 05:04:31 GMT

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.................................

Re: filter the data

Anil_Babu_Samineni — Thu, 08 Jun 2017 05:07:24 GMT

Expected result?

Re: filter the data

ravindraa — Thu, 08 Jun 2017 05:10:50 GMT

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

Re: filter the data

prma7799 — Thu, 08 Jun 2017 05:13:13 GMT

In back end

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

Re: filter the data

Anil_Babu_Samineni — Thu, 08 Jun 2017 05:17:01 GMT

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');

Re: filter the data

Anil_Babu_Samineni — Thu, 08 Jun 2017 05:17:51 GMT

And won't work, Should be in OR operator

Re: filter the data

prma7799 — Thu, 08 Jun 2017 05:23:52 GMT

PFA..

Re: filter the data

ravindraa — Thu, 08 Jun 2017 05:39:23 GMT

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