topic If statement for multiple argument in QlikView

If statement for multiple argument

Karim_Khan — Thu, 20 Aug 2015 11:19:01 GMT

Hi Team,

By applying below login I am able to remove 'UNKNOWN' from my data.

=IF([End Customer Global Ultimate Name] <>'UNKNOWN' ,[End Customer Global Ultimate Name],NULL())

But I have one more non usable field which is 'Uknown' I wanted to remove that also.

Pls help me how to apply this multiple logic.

Regards,

alexandros17 — Thu, 20 Aug 2015 11:21:24 GMT

Load again the table without the field 'Unknow'

Anonymous — Thu, 20 Aug 2015 11:22:19 GMT

try

if match([End Customer Global Ultimate Name],'UNKNOWN','Uknown')=0,[End Customer Global Ultimate Name],NULL())

in match you define all values you donot want

if only UNKNOWN , UnKnown or similiar you may use upper function to convert all in upper case letters

kkkumar82 — Thu, 20 Aug 2015 11:23:28 GMT

If you mean to say you have UNKNOWN and unknown in your data, try this

=IF([End Customer Global Ultimate Name] <>'UNKNOWN' OR [End Customer Global Ultimate Name] <>'UNKNOWN' ,[End Customer Global Ultimate Name],NULL())

Thanks

Kiran Kumar

Karim_Khan — Thu, 20 Aug 2015 11:26:22 GMT

Tnx buddy

Peter_Cammaert — Thu, 20 Aug 2015 11:43:11 GMT

Or try:

=IF (UPPER([End Customer Global Ultimate Name]) <> 'UNKNOWN', [End Customer Global Ultimate Name], NULL())

to capture every possible capitalization of the word Unknown.

sasiparupudi1 — Thu, 20 Aug 2015 12:15:01 GMT

IF([End Customer Global Ultimate Name] <>'UNKNOWN' or [End Customer Global Ultimate Name] <>'Uknown' ,[End Customer Global Ultimate Name],NULL())

qlikviewwizard — Thu, 20 Aug 2015 14:13:37 GMT

Please use as shown in below script:

Hi,

qlikviewwizard — Thu, 20 Aug 2015 14:14:41 GMT

Hope this will help you.

Kushal_Chawda — Thu, 20 Aug 2015 14:20:34 GMT

Try,

IF(lower(trim([End Customer Global Ultimate Name]))<>'unknown' ,[End Customer Global Ultimate Name],NULL())