Exclude values based on IF condition

Wed, 05 Aug 2015 14:56:25 GMT

Hi All,

I have 2 QVDS files which I need to restrict the data at QVD level based on Region. I have a "CODE"column which has codes and other column which has "Region". Both are coming from different QVDs but mapped with common key.

I have 'US', 'UK', 'Asia', 'Other' in the region list. I need to exclude some values in the "CODE" Column for some countries.

In other words, I need to Exclude A,B,C,D from the CODE column for US

AND E,F,G,H for Asia.

i.e IF Region = US THEN Exclude A,B,C,D from the CODE column

AND

IF Region = Asia THEN Exclude E,F,G,H from the CODE column

Is that be possible to restrict the data based on the above condition?

Thanks

Re: Exclude values based on IF condition

MK_QSL — Wed, 05 Aug 2015 15:10:21 GMT

Load * From QVDName

Where Not (

(Match(Code,'A','B','C','D') and Region = 'US') or

(Match(Code,'E','F','G','H') and Region = 'Asia')

)

Re: Exclude values based on IF condition

Thu, 06 Aug 2015 13:57:30 GMT

Thanks Manish!

topic Exclude values based on IF condition in QlikView

Exclude values based on IF condition

Re: Exclude values based on IF condition

Re: Exclude values based on IF condition