topic Re: If..Else advice Needed Please in QlikView

If..Else advice Needed Please

Mon, 27 May 2013 04:25:21 GMT

Hello Everyone,

Would anyone able to tell me what does the statement below do please?

if((Left(Originatingcompanymnemonic, if((findoneof(Originatingcompanymnemonic, ' '))=0, (len(Originatingcompanymnemonic)), findoneof(Originatingcompanymnemonic, ' ')-1)))='-', NULL(), (Left(Originatingcompanymnemonic, if((findoneof(Originatingcompanymnemonic, ' '))=0, (len(Originatingcompanymnemonic)), findoneof(Originatingcompanymnemonic, ' ')-1)))) as MOC_OrgCoy,

Thank you very much for your kind advise!

Re: If..Else advice Needed Please

Mon, 27 May 2013 05:58:45 GMT

HI ,

The above code is used to replace the ' - ' value by the null() value .

Basically some DataSource may contain '-' value instead of null values .

The Field Originatingcompanymnemonic might be containing '-' instead of null

so this expression is used to replace the '-' with the null() values.

Regards

Yusuf

Re: If..Else advice Needed Please

Mon, 27 May 2013 07:05:57 GMT

Thank you very much Yusuf for your prompt advice! Would you be able to advise further what does the below statement do please:

(Left(Originatingcompanymnemonic, if((findoneof(Originatingcompanymnemonic, ' '))=0, (len(Originatingcompanymnemonic)), findoneof(Originatingcompanymnemonic, ' ')-1))

Perhaps I can call you to have a quick chat?

Re: If..Else advice Needed Please

Mon, 27 May 2013 07:06:35 GMT

Thank you very much Yusuf for your prompt advice! Would you be able to advise further what does the below statement do please:

(Left(Originatingcompanymnemonic, if((findoneof(Originatingcompanymnemonic, ' '))=0, (len(Originatingcompanymnemonic)), findoneof(Originatingcompanymnemonic, ' ')-1))

Perhaps I can call you to have a quick chat?

Re: If..Else advice Needed Please

Mon, 27 May 2013 07:07:20 GMT

(Left(Originatingcompanymnemonic, if((findoneof(Originatingcompanymnemonic, ' '))=0, (len(Originatingcompanymnemonic)), findoneof(Originatingcompanymnemonic, ' ')-1))

What is the above statement trying to do please?

Re: If..Else advice Needed Please

Mon, 27 May 2013 07:11:25 GMT

Hi Yusuf!

Thank you for your prompt advice!

Would you kindly advise what is the below statement trying to do pls?

(Left(Originatingcompanymnemonic, if((findoneof(Originatingcompanymnemonic, ' '))=0, (len(Originatingcompanymnemonic)), findoneof(Originatingcompanymnemonic, ' ')-1))

Thanks!

Jeremiah Lee

Product Manager for eWindow®, Global Trading Services

Platts

12 Marina Boulevard

#23-01, Marina Bay Financial Centre Tower 3

Singapore 018982

DID (65) 6530 6415 | Support (65) 6530 6530

Mobile (65) 9108 4192 | F (65) 6532 2700

Yahoo : jleeka75@yahoo.com<mailto:jleeka75@yahoo.com>

www.platts.com<http://www.platts.com/>

Re: If..Else advice Needed Please

kumarnatarajan — Mon, 27 May 2013 07:14:45 GMT

Hi,

Send Some Sample data for Originatingcompanymnemonic .

This field type of data are contain.

Re: If..Else advice Needed Please

Mon, 27 May 2013 07:19:16 GMT

Here you go..

Jeremiah Lee

Product Manager for eWindow®, Global Trading Services

Platts

12 Marina Boulevard

#23-01, Marina Bay Financial Centre Tower 3

Singapore 018982

DID (65) 6530 6415 | Support (65) 6530 6530

Mobile (65) 9108 4192 | F (65) 6532 2700

Yahoo : jleeka75@yahoo.com<mailto:jleeka75@yahoo.com>

www.platts.com<http://www.platts.com/>

Re: If..Else advice Needed Please

Mon, 27 May 2013 07:35:03 GMT

Hi,

It is trying to find the ' ' ( space in the field value string) .

If there is space it remove the text after the space .

For example If you consider a fieldvalue "Amer ca" this is the text then it will consider only "Amer" .

Regards

Yusuf

Re: If..Else advice Needed Please

Mon, 27 May 2013 07:39:45 GMT

Hi Yusuf,

Thanks again for that.

Possible if I could have a quick call with you on this please?

Thanks very much!

Jeremiah Lee

Product Manager for eWindow®, Global Trading Services

Platts

12 Marina Boulevard

#23-01, Marina Bay Financial Centre Tower 3

Singapore 018982

DID (65) 6530 6415 | Support (65) 6530 6530

Mobile (65) 9108 4192 | F (65) 6532 2700

Yahoo : jleeka75@yahoo.com<mailto:jleeka75@yahoo.com>

www.platts.com<http://www.platts.com/>

Re: If..Else advice Needed Please

Mon, 27 May 2013 07:45:31 GMT

Hi,

Yes really i appreciate .

But At present i could not take the call .

I can avaialble after 6 hours from now.

But still i can reply to your post .

Sorry for the inconvenience .

Regards

Yusuf

Re: If..Else advice Needed Please

Mon, 27 May 2013 07:49:55 GMT

Hmm..6 hours will be my night time..around 10pm. If you can call me at 65-9108-4192, that would be appreciated much!

Otherwise, I just need to speak to someone in your team to guide me thru what does the statement do step by step..should be quick..

Thanks,

Jeremiah Lee

Product Manager for eWindow®, Global Trading Services

Platts

12 Marina Boulevard

#23-01, Marina Bay Financial Centre Tower 3

Singapore 018982

DID (65) 6530 6415 | Support (65) 6530 6530

Mobile (65) 9108 4192 | F (65) 6532 2700

Yahoo : jleeka75@yahoo.com<mailto:jleeka75@yahoo.com>

www.platts.com<http://www.platts.com/>

Re: If..Else advice Needed Please

kumarnatarajan — Mon, 27 May 2013 07:56:43 GMT

Hi,

Try this one.

Ex: if(len(Trim(Originatingcompanymnemonic))>0,SubField(Originatingcompanymnemonic,' ',1),Null()) as MOC_OrgCoy

Re: If..Else advice Needed Please

Mon, 27 May 2013 07:58:55 GMT

Hi Kumar,

Would it be possible if I give you a quick call please?

Thanks,

Jeremiah Lee

Product Manager for eWindow®, Global Trading Services

Platts

12 Marina Boulevard

#23-01, Marina Bay Financial Centre Tower 3

Singapore 018982

DID (65) 6530 6415 | Support (65) 6530 6530

Mobile (65) 9108 4192 | F (65) 6532 2700

Yahoo : jleeka75@yahoo.com<mailto:jleeka75@yahoo.com>

www.platts.com<http://www.platts.com/>

Re: If..Else advice Needed Please

kumarnatarajan — Mon, 27 May 2013 08:55:07 GMT

Hi,

Find the attached file.i think you are looking this type of syntex. Go to help(F1) there you can able to read about all the function

Re: If..Else advice Needed Please

Mon, 27 May 2013 09:12:14 GMT

Got it, it is clear now.

I got a last advice request..based on your last statement..

if(len(Trim(Originatingcompanymnemonic))>0,SubField(Originatingcompanymnemonic,' ',1),Null()) as MOC_OrgCoy,

Some Originatingcompanymnemonic value is “-“ and I need to return a NULL for those records..how do I do it based on your statement above please?

Jeremiah Lee

Product Manager for eWindow®, Global Trading Services

Platts

12 Marina Boulevard

#23-01, Marina Bay Financial Centre Tower 3

Singapore 018982

DID (65) 6530 6415 | Support (65) 6530 6530

Mobile (65) 9108 4192 | F (65) 6532 2700

Yahoo : jleeka75@yahoo.com<mailto:jleeka75@yahoo.com>

www.platts.com<http://www.platts.com/>

Re: If..Else advice Needed Please

kumarnatarajan — Mon, 27 May 2013 09:17:13 GMT

Hi,

try this

Ex: if(len(Trim(Country))>0 and Trim(Country)<>'-',SubField(Country,' ',1),Null()) as MOC_OrgCoy

Re: If..Else advice Needed Please

Mon, 27 May 2013 09:28:45 GMT

It works!

Thanks very much Kumar!

Jeremiah Lee

Product Manager for eWindow®, Global Trading Services

Platts

12 Marina Boulevard

#23-01, Marina Bay Financial Centre Tower 3

Singapore 018982

DID (65) 6530 6415 | Support (65) 6530 6530

Mobile (65) 9108 4192 | F (65) 6532 2700

Yahoo : jleeka75@yahoo.com<mailto:jleeka75@yahoo.com>

www.platts.com<http://www.platts.com/>

Re: If..Else advice Needed Please

kumarnatarajan — Mon, 27 May 2013 09:33:26 GMT

Hi,

Ok, you got the result.which is the right answer click there "Correct answer" then close your question