Trying to remove data in load

[thom_sundberg]

Hi,

I have a problem with the bold lines:

FROM
[D:\QlikView Storage\Private Data\Source Documents\In Production\Ekonomi\Data\02_Transform\UBW\Verifikationer.qvd] (qvd)
where left(%Key_Konto,2) = 'NK'
and mid(%Key_Konto, 4,1)>=4 and mid(%Key_Konto, 4,1)<8
and len(Utfall_Belopp)>0
and right(%Key_Konto,5)<>48500
and right(%Key_Konto,5)<>46301 //Tillagt av Thom 190411 (ta bort kundval)
and right(%Key_Konto,5)<>46321 //Tillagt av Thom 190411 (ta bort kundval)
and left(SubField(%Key_Motpart,'|',2),1)>=8 //motpart 8-9*
and left(Verifikationsnr,2)<> 29 //verkar vara periodiseringar, tar bort dem
and year(%Key_Datum)>=$(StartYearUBW)
and len(subfield(%Key_Leverantör,'|',2))>0;

The first one work <>48500 but not for <>46301 and <>46321. What am I doing wrong?

[Channa · Accepted solution]

use NotMatch( right(%Key_Konto,5)=48500,46301 ,46321 )

[thom_sundberg]

Thanks for the answer.

Needed some '' around the numbers.

use NotMatch( right(%Key_Konto,5)='48500','46301' ,'46321' )