topic Re: Return only a portion of a variable in QlikView

Return only a portion of a variable

zagzebski — Fri, 06 Oct 2017 04:02:42 GMT

I have the following

Variable1 = North

Variable2 = North East

I need the ability to create an expression that would remove the portion of Variable1 that is in Variable2. In the example above the expression would return "East" because "North" would be removed from Variable2 because it is also in Variable1.

Thanks for any help!

Re: Return only a portion of a variable

antoniotiman — Fri, 06 Oct 2017 05:01:13 GMT

Hi Steve,

may be

Replace(Variable2,Variable1,'')

Regards,

Antonio

Re: Return only a portion of a variable

jayshrinipurte — Fri, 06 Oct 2017 06:54:04 GMT

Hi Steve,

According to my understanding whatever you asked i tried solving it

plz check whether it is matching your requirement

If(SubField($(vVariable2),' ',1)=SubField($(vVariable1),1),Replace($(vVariable2),$(vVariable1),''))

Regards,

Jayshri

Re: Return only a portion of a variable

zagzebski — Fri, 06 Oct 2017 13:13:30 GMT

Thanks so much!

Re: Return only a portion of a variable

jayshrinipurte — Fri, 06 Oct 2017 13:34:51 GMT

Welcome Steve