topic Re: help with expression in QlikView

help with expression

arusanah — Wed, 09 Nov 2016 17:13:58 GMT

=Date(Date#(left(subfield('ABC_Sept2016','_',2),8),'MMMYYYY'),'MMM YYYY')

expression is throwing me error not returning anything . The outer DATE() is not working . I used exactly same expression for other file it works perfectly fine . but for this one till Date#() it is working fine but outer Date() throwing error .pls help

Re: help with expression

sunny_talwar — Wed, 09 Nov 2016 17:21:47 GMT

Your month is 4 letters, rather than the normal three letters?

Sept vs Sep... Did you change the environmental variable accordingly?

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sept;Oct;Nov;Dec';

Re: help with expression

arusanah — Wed, 09 Nov 2016 18:48:26 GMT

yes I had already done that , but your observation still help me find my mistake .a very minute error in my expression ..

thanks again sunny boy

Re: help with expression

antoniotiman — Wed, 09 Nov 2016 18:55:52 GMT

add to the Sunny's answer, try

Alt(Date(Date#(subfield('ABC_sept2016','_',2),'MMMYYYY'),'MMM YYYY'),
Date(Date#(subfield('ABC_sept2016','_',2),'MMMMYYYY'),'MMM YYYY'))

Regards

Antonio

Re: help with expression

sunny_talwar — Thu, 10 Nov 2016 02:13:52 GMT

It might be helpful if you can share what error were you making as it might help someone else in the future to not repeat the same error?

Thanks,

Sunny