topic Re: Condition is not working in Load script in QlikView

Condition is not working in Load script

Thu, 06 Aug 2015 05:57:55 GMT

Hi All,

Please find the attached Qvw and Data file.

I have a condition in data load script where

if([WBS Element]<>null(),[WBS Element],if(Len(Assignment)>=6,Assignment,H.Text)) as WBS_Code_Final

If the data in WBS Element field is empty then it should check for Assignment field. If the length of assignment field is >=6 it should take that value otherwise H.Test as the WBS_Final_code.

If the data is not null in WBS Element then WBS Element should be take as WBS_Code_Final.

Please let me know if you need any clarifications.

Regards,

Keerthi KS

Re: Condition is not working in Load script

Kushal_Chawda — Thu, 06 Aug 2015 06:04:02 GMT

Please see the attached.

Re: Condition is not working in Load script

robert_mika — Thu, 06 Aug 2015 06:08:34 GMT

if(len(trim([WBS Element]))>0,[WBS Element],if(Len(Assignment)>=6,Assignment,H.Text)) as WBS_Code_Final

Re: Condition is not working in Load script

Thu, 06 Aug 2015 06:11:42 GMT

Thanks a lot

Re: Condition is not working in Load script

jonathandienst — Thu, 06 Aug 2015 06:14:08 GMT

You cant compare nulls like that. Use:

if(Not(IsNull([WBS Element])), [WBS Element], if(Len(Assignment) >= 6, Assignment, H.Text)) as WBS_Code_Final